Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Row to Column

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Row to Column

Highlighted
Partner
Partner

Re: Row to Column

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

Highlighted
Creator III
Creator III

Re: Row to Column

Hi Manoj,

Please use below script.


Generic  LOAD [User ID],
    
Segment,
    
Bills
FROM

(
ooxml, embedded labels, table is Sheet7);

1234.jpg





Highlighted
Partner
Partner

Re: Row to Column

Thanks Marcus. It worked

Highlighted
Partner
Partner

Re: Row to Column

Thanks for your suggestion