Complete the missing categories

[Anonymous]

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!

[swuehl · Accepted solution]

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;