topic Re: Text output file in "vertical-mode" in Talend Studio

Text output file in "vertical-mode"

tldusr — Tue, 14 Dec 2021 17:33:06 GMT

Hi all,

is there a way to outputting fields (for example of a csv) in a "vertical mode" as follow:

input.csv:

Column1;Column2;Column3

01;name1;surname1

02;name2;surname2

03;name3;surname3

output.txt:

name1

surname1

name2

surname2

name3

surname3

I tried with tPivotToColumnDelimited but I don't understand how it works.

Thanks

Anonymous — Wed, 15 Dec 2021 11:08:33 GMT

Try tNormalize component, concatenate three columns to one column on a tJavaRow, and then use tNormalize to normalize the rows.

Regards

Shong

tldusr — Sat, 18 Dec 2021 13:28:24 GMT

It works! Thank you so much!