Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Nevermind, found it:
http://community.qlik.com/message/78337#78337
Alex's solution does exactly what I needed!
Nevermind, found it:
http://community.qlik.com/message/78337#78337
Alex's solution does exactly what I needed!