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: 
Mattia
Creator II
Creator II

How to Left Join() a table with another below?

Hi,

if i have 2 tables like the following:

TABLE1:

...

TABLE2:

...

How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?

I can't change the order of the tables because i need to insert an expression in TABLE2 that involve also some fields of TABLE1.

Please, anyone have a suggest?

Thanks,

Mattia

Labels (1)
1 Solution

Accepted Solutions
bharathadde
Creator II
Creator II

TABLE1:

...

TABLE2:

...

left join

Load

...

Resident TABLE1;

Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.

Hope this helps

View solution in original post

1 Reply
bharathadde
Creator II
Creator II

TABLE1:

...

TABLE2:

...

left join

Load

...

Resident TABLE1;

Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.

Hope this helps