Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Transpose Rows into Columns on Load

Hi,

I have been given a qvd file that when loaded looks like this :

Capture.PNG

What I need to to for every ID is have a single row and the Order Numbers as columns :

    

ID  123
1508892S258S571A544

There could be a maximum of 10 Order Numbers.

I need to do this so I can join this onto another QVD in another Dashboard.  Is this possible?

Many thanks

Tags (2)
2 Replies
MVP & Luminary
MVP & Luminary

Re: Transpose Rows into Columns on Load

I'd suggest loading the raw data first, and then looping through the 10 Order Number values (using the function FieldValue() ) and loading the corresponding Codes into the corresponding field names, and concatenating all these loads. Perhaps someone with enough spare time could offer this piece of script...

cheers,

Oleg Troyansky

Learn advanced Qlik techniques in my book QlikView Your Business.

MVP & Luminary
MVP & Luminary

Re: Transpose Rows into Columns on Load

Add the GENERIC prefix to the load.

Data:

GENERIC

LOAD ID,Order_Number, Code  INLINE [

ID, Code, Order_Number

1508892, A544, 3

1508892, S258, 2

1508892, S571, 1

];

-Rob

http://masterssummit.com

http://qlikviewcookbook.com