topic Re: How to split tMap to tFileOutputExcel into separate lines in Talend Studio

How to split tMap to tFileOutputExcel into separate lines

Anonymous — Wed, 27 Jun 2018 15:52:03 GMT

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

Re: How to split tMap to tFileOutputExcel into separate lines

fdenis — Wed, 27 Jun 2018 16:49:45 GMT

I guess you are looking for tNormalize.

Re: How to split tMap to tFileOutputExcel into separate lines

Anonymous — Wed, 04 Jul 2018 12:46:56 GMT

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

Re: How to split tMap to tFileOutputExcel into separate lines

fdenis — Wed, 04 Jul 2018 13:04:00 GMT

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)