Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tldusr
Contributor
Contributor

Text output file in "vertical-mode"

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

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

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

 

Regards

Shong

View solution in original post

2 Replies
Anonymous
Not applicable

Hi

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

 

Regards

Shong

tldusr
Contributor
Contributor
Author

It works! Thank you so much!​