Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Transpose few fields in QlikView

How to transpose two fields out of three in a QVD while loading.

3 Replies
Not applicable
Author

untitled.JPG

I want to convert the Table A as Table B

whiteline
Master II
Master II

Hi.

You could use where statement and 4 different loads (for the provided sample).

Or you could use 'generic load' as more agile approach:

http://community.qlik.com/message/105595#105595

Not applicable
Author

Once check this...But Table-A is more clear when compared to Table-B na?? So dont make ur data look complex..!!

Let me know once you check it..!!

I agree with what Gysbert Wassenaar says....about your purpose...