Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Row to Column

Hi All,

I am having data in below format, would like to convert into Columns. Please suggest how to acheive.

 

User IDSegmentBills
1Seg112
1Seg213
2Seg115
2Seg212
3Seg111
3Seg312
4Seg116
4Seg212
4Seg3

10

expected result :

 

User IDSeg1Seg2Seg3Seg4
11213
21512
31112
4161210
1 Solution

Accepted Solutions
marcus_sommer

5 Replies
marcus_sommer

Have a look here: The Generic Load

- Marcus

Mark_Little
Luminary
Luminary

Hi,

I was going to suggest looking at the cross table option. But I think Marcus's option is better.

Also like to thank Marcus for pointing it out and the good blog post by Henric.

Mark

neha_sri
Creator III
Creator III

Hi Manoj,

Please use below script.


Generic  LOAD [User ID],
    
Segment,
    
Bills
FROM

(
ooxml, embedded labels, table is Sheet7);

1234.jpg





manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Thanks Marcus. It worked

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Thanks for your suggestion