topic Symmetric difference in load script in QlikView

Symmetric difference in load script

Tue, 16 Nov 2010 20:35:58 GMT

Hello, I need to load two tables, but i need the Symmetric difference between them in script load.

For example:

Table 1:

Table 2:

RESULT TABLE:

Thanks 😉

Tue, 16 Nov 2010 20:41:31 GMT

hello,

read tab2 first, then read tab1 WHERE NOT EXISTS rows from tab1. EXISTS function is the key to success!

regards

Tue, 16 Nov 2010 21:44:00 GMT

Thank you for your help,

I attach my script:

fruits1:
LOAD id
FROM ..\Datos\fruits2.csv (ansi, txt, delimiter is ';', embedded labels, msq);

fruits2:
LOAD id,
desc
FROM ..\Datos\fruits.csv (ansi, txt, delimiter is ';', embedded labels, msq)
WHERE not exists(id);

DROP TABLE fruits1;