Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm working on a new dataset, and I'm having trouble transposing data to a more usuable format.
Simplified example of source data:
ID# | TypeID | Value |
100 | ItemNumber | Item01 |
100 | Description | Desc01 |
100 | Lenght | 12 |
100 | Width | 12 |
100 | Height | 12 |
110 | ItemNumber | Item02 |
110 | Description | Desc02 |
110 | Lenght | 16 |
110 | Width | 12 |
110 | Height | 10 |
120 | ItemNumber | Item03 |
120 | Description | Desc03 |
120 | Lenght | 18 |
120 | Width | 8 |
120 | Height | 12 |
Goal is to show as:
ID# | ItemNumber | Description | Lenght | Width | Height |
100 | Item01 | Desc01 | 12 | 12 | 12 |
110 | Item02 | Desc02 | 16 | 12 | 10 |
120 | Item03 | Desc03 | 18 | 8 | 12 |
I've now set up a separate load of source data for every column in the result, but there must a better way I don't know of yet.
Working in Qlk Sense August 2022 Patch 13
You may apply the The Generic Load - Qlik Community - 1473470.
You may apply the The Generic Load - Qlik Community - 1473470.
That worked, thanks!