Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
01
name1
surname1
02
name2
surname2
03
name3
surname3
I tried with tPivotToColumnDelimited but I don't understand how it works.
Thanks
Hi
Try tNormalize component, concatenate three columns to one column on a tJavaRow, and then use tNormalize to normalize the rows.
Regards
Shong
Hi
Try tNormalize component, concatenate three columns to one column on a tJavaRow, and then use tNormalize to normalize the rows.
Regards
Shong
It works! Thank you so much!