Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
PeterPeter
Contributor II
Contributor II

Datatable removing rows based on data from other table

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

1

2

3

4

5

 

and I have datatable2:

Column1

 

I want to have as result:

Datatable1:

Column1

1

2

4

5

Labels (1)
1 Reply
anat
Master
Master

t1:

load f1 as f2;

load * inline [

f1

3

];

t2:

load * inline [

f1

1

2

3

4

5

] where not exists(f2,f1);

drop table t1;