How to read multi record in 1 row with Excel

[Anonymous]

This is my data in Excel

But, when I read it to talend, It does not display like excel file.

Please show me, How can do it?

[billimmer · Accepted solution]

You can use a tJavaFlex component and store the value in the first column.  Then when the first column is blank, assign it the value of the previous first column.