topic Help in Scripting in QlikView

Help in Scripting

Mon, 04 May 2015 13:36:47 GMT

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 — Mon, 04 May 2015 13:45:44 GMT

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 — Mon, 04 May 2015 14:09:49 GMT

HI Asma ,

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

Have a good day !!