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

Announcements
Join us in Bucharest on Sept 18th 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;