topic Re: Join Question in QlikView

Join Question

jduluc12 — Wed, 20 Apr 2022 05:04:02 GMT

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

Table_2 - Table_1 = Table_3.

Table_1

Table_2

Table_3:

Thanks

Jean

PrashantSangle — Wed, 20 Apr 2022 05:35:53 GMT

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