Symmetric difference in load script

[#1]

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 😉

[#2 · Accepted solution]

hello,

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

regards

[#3]

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;