Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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