Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kfir1987
Contributor II
Contributor II

Remove Rows From Table Based on Another Table

Hi, 

I have two table: 

1. [Machine Data] - There are 3 columns:

SN, Job#, Time

2. [Job info] - there are 3 columns: 

SN, Job#, Completion status.

 

I have found few job#, SN (The key is both of the fields) on [Job Info] that not appear on [Machine Data] and I want to filter them out from [Job Info]. What is the best practice for this operation? By flag? Minus operation? 

 

Thanks for the help 

2 Replies
Mark_Little
Luminary
Luminary

Hi,

I am sorry i am not following the question, could please supply a little more information and if you could show an example of the issue i.e. what you are seeing and what you like to see.

Mark
kfir1987
Contributor II
Contributor II
Author

Hi, 

I will give an example and I hope the question will be more clear: 

The table contains the below data: 2018-12-11 12_00_33-Book1 - Excel.png

I want to remove all the rows on  [Machine Data]  that not appear on [Job info]  (The key is SN and Job#).

On the above example, I expect that on  [Machine Data]  the row with the SN - 4 and  Job# - 97 will be deleted.

  Why did I expect that? because the SN and Job # do not exist on Job Info.

Thanks