Datatable removing rows based on data from other table

PeterPeter — Mon, 24 Jan 2022 16:04:12 GMT

Hello, so I think I have a relative simple question, but im wondering how you would do this in Qlik Sense.

I have datatable1:

Column1

and I have datatable2:

Column1

I want to have as result:

Datatable1:

Column1

Re: Datatable removing rows based on data from other table

anat — Tue, 25 Jan 2022 06:11:28 GMT

t1:

load f1 as f2;

load * inline [

];

t2:

load * inline [

] where not exists(f2,f1);

drop table t1;