Exctracting data from excel

How can extract data from one excel cell on the top an present it as separate field + table from below?

Big John

You can use new function Keep value
It transfers

Customer Id Order Amount
1 1 56
Null or empty string 2 456
Null or empty string 3 45

Into
Customer Id Order Amount
1 1 56
1 2 456
1 3 45

More complex data transformation example

Date: 01/01/2009
Customer Id Order Amount
1 1 56
1 2 456
1 3 45

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

Hope this helps
Mike

Thank you

I will give this one a try

I have another another question

How can I join two excel files?

You can use ODBC or Ole DB to run SQL against Excel file
But due to the number of bugs in excel odbc driver it is practically useless

Or you can use lookup transformation object

Here is on-line tutorial
www.etl-tools.com/online-tutorials/advan...g-lookup-object.html

Mike