topic Re: how to remove the row as in ID from Second Table which is being already appeared in First Table in QlikView

how to remove the row as in ID from Second Table which is being already appeared in First Table

alis2063 — Wed, 25 Nov 2020 16:16:04 GMT

how to remove the row from Second Table which is being already appeared in First Table

Exp

we have two tables as below

First Table

[Jan]:

load * inline [ID,Month

SN1,Jan

SN2,Jan

SN3,Jan

];

Second Table:

Feb:

load * inline [ID,Month

SN3,Feb

SN4,Feb

SN5,Feb ]

We are expecting data from Second table as below

SN4,Feb

SN5,Feb

As SN3 as in ID is already appeared in First Table as Jan.

Please assist me .

New to QlikView‌

Re: how to remove the row as in ID from Second Table which is being already appeared in First Table

Nicole-Smith — Fri, 26 May 2017 17:33:43 GMT

[Jan]:

load * inline [ID,Month

SN1,Jan

SN2,Jan

SN3,Jan

];

Feb:

load * where not exists(ID);

load * inline [ID,Month

SN3,Feb

SN4,Feb

SN5,Feb

];

Re: how to remove the row as in ID from Second Table which is being already appeared in First Table

alis2063 — Fri, 26 May 2017 17:36:50 GMT

thanks ..