Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jose_teglia
New Contributor

Join tables in order to get values that are just in the first one

Hello, I'm trying to perform something like a LEFT JOIN WHERE between 2 tables in order to get the values that are exclusive for the first table.

What I have is like:

TableX:

LOAD A, B Resident TableA;

Left Join (TableX)

LOAD A Resident TableA where IsNull(A);

It looks like the where clause is not working properly and I'm still getting values from TableB. Any help or idea?

Thanks!

2 Replies
Highlighted
atkinsow
Valued Contributor II

Re: Join tables in order to get values that are just in the first one

One way.

TableY:

Load A

Resident TableB;

noconcatenate

TableX:

Load A

Resident TableA

where not exists(A);

Drop TableY;

jose_teglia
New Contributor

Re: Join tables in order to get values that are just in the first one

Thanks for your comments, but it looks like it did not work. On that way, TableX is created without any value.

Also, I can´t see the relation between TableX and TableY based on your example (sorry, I'm sooo new on this).