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

Announcements
Join us in NYC Sept 4th 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!​