Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
wanyunyang
Contributor

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

Re: Data Load Editor LEFT JOIN

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...;

2 Replies
agigliotti
Honored Contributor II

Re: Data Load Editor LEFT JOIN

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...;

Re: Data Load Editor LEFT JOIN

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...;

Community Browser