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

[alis2063]

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‌

[Nicole-Smith · Accepted solution]

[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

];

[alis2063]

thanks ..