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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Pick only those records from column A that is not present in Column B

Hey, I have a table that contains 2 columns named AQPART and  AQMTLP.

I only want to fetch those records from AQPART, which are present in column AQPART and not present in column AQMTLP. Rest all records should be skipped.

risabhroy_03_0-1657514318374.png

 

Please help me achieve this.

 

Labels (4)
1 Solution

Accepted Solutions
sidhiq91
Specialist II
Specialist II

@risabhroy_03  You can perform in 2 methods. I have listed both the methods below. You can pick  anyone.

Method1:

NoConcatenate
Table1:
Load * Inline [
AQPART,AQMTLP
AA27266,MTLA64190
AA31578,A46402
AA34039,AA37259,
AA37259,B0A5318
];

NoConcatenate
Table2:
Load * Resident Table1
where exists(AQMTLP,AQPART);


Drop table Table1;

Method2:

NoConcatenate
Table1:
Load * Inline [
AQPART,AQMTLP
AA27266,MTLA64190
AA31578,A46402
AA34039,AA37259,
AA37259,B0A5318
];

 

Inner join(Table1)
Load AQMTLP as AQPART
Resident Table1;

If this resolves your issue, please like and accept it as a solution.

 

View solution in original post

1 Reply
sidhiq91
Specialist II
Specialist II

@risabhroy_03  You can perform in 2 methods. I have listed both the methods below. You can pick  anyone.

Method1:

NoConcatenate
Table1:
Load * Inline [
AQPART,AQMTLP
AA27266,MTLA64190
AA31578,A46402
AA34039,AA37259,
AA37259,B0A5318
];

NoConcatenate
Table2:
Load * Resident Table1
where exists(AQMTLP,AQPART);


Drop table Table1;

Method2:

NoConcatenate
Table1:
Load * Inline [
AQPART,AQMTLP
AA27266,MTLA64190
AA31578,A46402
AA34039,AA37259,
AA37259,B0A5318
];

 

Inner join(Table1)
Load AQMTLP as AQPART
Resident Table1;

If this resolves your issue, please like and accept it as a solution.