Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner
Partner

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
MVP & Luminary
MVP & Luminary

5 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

mark6505
Partner
Partner

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
Partner
Author

Thanks Marcus. It worked

manojkulkarni
Partner
Partner
Author

Thanks for your suggestion