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: 
wanyunyang
Creator III
Creator III

Data Load Editor LEFT JOIN

Hi guys,

In my data load editor, I have two tables like:

table1:

LOAD a AS A, b AS B, c AS C;

SELECT a,b,c FROM ... WHERE...;

table2:

LOAD a AS A, b AS B, d AS D;

SELECT a,b,d FROM ... WHERE...;


I'm trying to do table1 LEFT JOIN table2. What should the syntax be?


Thanks for help!

1 Solution

Accepted Solutions
sunny_talwar

May be this

table1:

LOAD a AS A, b AS B, c AS C;

SELECT a,b,c FROM ... WHERE...;

Left Join (table1)

LOAD a AS A, b AS B, d AS D;

SELECT a,b,d FROM ... WHERE...;

View solution in original post

2 Replies
agigliotti
Partner - Champion
Partner - Champion

by the below code:

table1:

LOAD a AS A, b AS B, c AS C;

SELECT a,b,c FROM ... WHERE...;

left join

LOAD a AS A, b AS B, d AS D;

SELECT a,b,d FROM ... WHERE...;

sunny_talwar

May be this

table1:

LOAD a AS A, b AS B, c AS C;

SELECT a,b,c FROM ... WHERE...;

Left Join (table1)

LOAD a AS A, b AS B, d AS D;

SELECT a,b,d FROM ... WHERE...;