Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
luca_bellotti
Contributor III
Contributor III

Joining two tables

Hi everyone,

I need to join (or keep I honestly don't know) two tables.

TABLE_1

CODE_STORECODE_DEPDATESALES
A102/01/2018100

A

103/01/201850
A201/01/201875
A202/01/201825
A301/01/2018100
A401/01/2018100

TABLE_2

CODE_STORECODE_DEPCODE_DEP2WEIGHT_%CODE_DEP_MINDESC_DEP_MINDEP_MIN

A

1

1a30%01RED01 - RED
A11b70%02BLUE02 - BLUE
A11a30%01RED01 - RED
A11b70%02BLUE02 - BLUE
A22a50%03YELLOW03 - YELLOW
A22b50%04GREEN04 - GREEN
A22a50%03YELLOW03 - YELLOW
A22b50%04GREEN04 - GREEN
A33a40%05ORANGE05 - ORANGE
A33b60%06BROWN06 - BROWN
A44a20%07BLACK07 - BLACK
A44b80%08WHITE08 - WHITE

What I need to get is something like this

CODE_STORECODE_DEPDATESALESCODE_DEP2WEIGHT_%CODE_DEP_MINDESC_DEP_MINDEP_MIN

A

1

02/01/20181001a30%01RED01 - RED
A102/01/20181001b70%02BLUE02 - BLUE
A103/01/2018501a30%01RED01 - RED
A103/01/2018501b70%02BLUE02 - BLUE
A201/01/2018752a50%03YELLOW03 - YELLOW
A201/01/2018752b50%04GREEN04 - GREEN
A202/01/2018252a50%03YELLOW03 - YELLOW
A202/01/2018252b50%04GREEN04 - GREEN
A301/01/20181003a40%05ORANGE05 - ORANGE
A301/01/20181003b60%06BROWN06 - BROWN
A401/01/20181004a20%07BLACK07 - BLACK
A401/01/20181004b80%08WHITE08 - WHITE

Any suggestions on how can I get this?

Thank you

1 Solution

Accepted Solutions
luca_bellotti
Contributor III
Contributor III
Author

I've managed to join the two tables by myself.

Here's my solution to the problem

TABLE_3:

NoConcatenate

Load *

Resident TABLE_2;

left join (TABLE_3)

Load *

Resident TABLE_1;

Drop Table TABLE_1;

Drop Table TABLE_2;


If anybody else has a better solution let me know.

Thanks again.

View solution in original post

1 Reply
luca_bellotti
Contributor III
Contributor III
Author

I've managed to join the two tables by myself.

Here's my solution to the problem

TABLE_3:

NoConcatenate

Load *

Resident TABLE_2;

left join (TABLE_3)

Load *

Resident TABLE_1;

Drop Table TABLE_1;

Drop Table TABLE_2;


If anybody else has a better solution let me know.

Thanks again.