Solved: Join Question - Qlik Community

jduluc12 · ‎2022-04-20

Hi

May I have a load script that produces a Tables_3 in this manner?

Table_2 - Table_1 = Table_3.

Table_1

ID

1

4

5

Table_2

ID

1

2

3

4

5

6

Table_3:

ID

2

3

6

Thanks

Jean

PrashantSangle · ‎2022-04-20

use not exist() like

Table1:

Load ID from Table1;

NoConcatenate

Load ID from Table2 where not exists(ID,ID);

Drop table Table1;

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2022-04-20