How to split tMap to tFileOutputExcel into separate lines

[Anonymous]

Hi,

In the attached tFileInputExcel (attached convertcsv-sample) I have columns:

additional_image_link/0/__cdata    
additional_image_link/1/__cdata    
additional_image_link/2/__cdata    
additional_image_link/3/__cdata

When the value of these is not null I want to write the values in tFileOutputExcel (attached fta_catalog_product_20180404_132826 - sample - working) out as separate lines.

e.g. in the example tFileOutputExcel, row 3, column DE is the value for "additional_image_link/0/__cdata" etc for the other additional images with each image URL value being written out as a separate row (4, 5, etc) in column DE.

Hope that makes sense.

Any ideas please on how I can take 1 input line of tFileInputExcel and split it out in tFileOutputExcel in separate lines?

Would appreciate any pointers.

Many thanks

Anil

[fdenis]

I guess you are looking for tNormalize.

[Anonymous]

Thanks for your response.

I'm not familiar with Talend tNormalize but I'll take a look.

Will that allow me to write out two separate lines for one input line and use tJavaRow to code the logic to write out the second line?

Thanks

Anil

[fdenis]

that allow you to write out two separate lines for one input line.
you can use what you want before or after (tjava is not the popular one)