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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
laughsmile
Contributor III
Contributor III

How to transpose dynamic columns into rows when using dynamic schema

Hello everyone

I am using dynamic schema to read data because the input file's column is changing dynamically.

How to transpose dynamic columns into rows?

Input File:

Articoli 561 575
Video 1049 1161
Tot 1610 1736

Expected Output:

Articoli Video Tot
561 1049 1610
575 1161 1736

 

Thanks in advance

Ryu

Labels (3)
1 Reply
Dave_Simo
Creator II
Creator II

Hello,

You can achieve the expected result with a job design like below

Dave_Simo_0-1721114170340.png

Best Regards