ETL and Data Integration tools - Modern ETL software for everyone

I have a file this

Customer Id Order Amount
1 1 10.2
null 2 50.66
null 3 12.66

and I want to transform it to something like this

Customer Id Order Amount
1 1 10.2
null 2 50.66
null 3 12.66

How can I do it?
Ian

Ian

You may use KeepValue function for it

Peter

Yes that works as expected.
Now I have another file to transform
The file is comma delimited.

Null,Date,01/01/2000
Order Date,Amount,Customer ID
01/01/2000,2,KK
01/01/2000,3,KK

How can I transform it?

Ian

You can do the following
USE Sequence to calculate record number
Connect Sequence and field to Calculation
and use this script
begin
if [F001]=1 then
Result := '[F002]'
else
Result := '';
end;
+ connect keep value to the calculation

Thank you very much for your quick response.

Ian