Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Complete the missing categories

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:

Dim1Dim2Measure
A145
A23
B245
B34
C3352
C145

The desired transformation shuld  convert the table into the following format:

Dim1Dim2Measure
A145
A23
A3
B1
B245
B34
C145
C2
C3

352

Any help would be appreciated!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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;

View solution in original post

1 Reply
swuehl
MVP
MVP

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;