Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
and_stepanyan
Contributor
Contributor

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;