Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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;