Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am relativly new in Qlik environment. To replicate my question I created a mini example. Below you can see the initial table I have:
Dim1 | Dim2 | Measure |
---|---|---|
A | 1 | 45 |
A | 2 | 3 |
B | 2 | 45 |
B | 3 | 4 |
C | 3 | 352 |
C | 1 | 45 |
The desired transformation shuld convert the table into the following format:
Dim1 | Dim2 | Measure |
---|---|---|
A | 1 | 45 |
A | 2 | 3 |
A | 3 | |
B | 1 | |
B | 2 | 45 |
B | 3 | 4 |
C | 1 | 45 |
C | 2 | |
C | 3 | 352 |
Any help would be appreciated!
Try something like
Data:
LOAD Dim1,
Dim2,
Measure
FROM
[https://community.qlik.com/thread/314603]
(html, codepage is 1252, embedded labels, table is @1);
AllDims:
LOAD DISTINCT Dim1 Resident Data;
JOIN
LOAD Dim2 Resident Data;
Left JOIN LOAD * Resident Data;
Drop Table Data;
Try something like
Data:
LOAD Dim1,
Dim2,
Measure
FROM
[https://community.qlik.com/thread/314603]
(html, codepage is 1252, embedded labels, table is @1);
AllDims:
LOAD DISTINCT Dim1 Resident Data;
JOIN
LOAD Dim2 Resident Data;
Left JOIN LOAD * Resident Data;
Drop Table Data;