How to split tMap to tFileOutputExcel into separate lines

Four Stars

How to split tMap to tFileOutputExcel into separate lines

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

Eleven Stars

Re: How to split tMap to tFileOutputExcel into separate lines

I guess you are looking for tNormalize.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: How to split tMap to tFileOutputExcel into separate lines

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

Eleven Stars

Re: How to split tMap to tFileOutputExcel into separate lines

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)

Francois Denis

Tag as "solved" for others! Kudos to thanks!