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

Reverse-Crosstable Transformation?

Hi Everyone,

I've got a data set, straight from a quirky source data system, that looks like the result of a crosstable transformation.... but shouldn't.  Basically, I have too many rows that should be columns -- so, what should be field names are appearing as row values in single a "Type" column.

If the number of Type values were small and static, I'd just do a series of LOAD * WHERE Type =1, 2, 3, etc... and concatenate the tables.  However...

What's the simplest way to perform a reverse-crosstable transformation?  Difficulty is there are also three preceding fields, including identity values, that shouldn't pivot.

Thanks,

DJ

1 Solution

Accepted Solutions
Not applicable
Author

Nevermind, found it:

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

Alex's solution does exactly what I needed!

View solution in original post

1 Reply
Not applicable
Author

Nevermind, found it:

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

Alex's solution does exactly what I needed!