In the attached tFileInputExcel (attached convertcsv-sample) I have columns:
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.
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?
Tag as "solved" for others! Kudos to thanks!