Help in Scripting

[#1]

Hi All,

I have two tables:

Table A: It has the list of some IDs.

Table B: It also has a list of some IDs. Some IDs may be the same as those in Table A while some can be different.

Now, I want that only those IDs should be loaded in table B which are not present in Table A.

Thanks,

Asma

[jonathandienst]

Hi

Like this:

TableA:

LOAD *

FROM TableA.xlsx (ooxml, ...);

LOAD *

FROM TableB.xlsx (ooxml, ...)

WHERE Not Exists (ID);

HTH

Jonathan

PS: you might want to concatenate the two tables - just add Concatenate before the second load

[arusanah]

HI Asma ,

PFA the test qvw.  if i understood ur requirement this is how it will work .

Have a good day !!