Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Unmatched values problem

Hi,

I want to display unmatched field values from second table where in first table they are present which function should I use?Lookup or applymap?

1 Solution

Accepted Solutions
sundarakumar
Specialist II
Specialist II

Use Not exists in load script.

-Sundar

View solution in original post

5 Replies
sundarakumar
Specialist II
Specialist II

Use Not exists in load script.

-Sundar

amit_saini
Master III
Master III

Hi Vijeta,

This can be acheived by Lkup function . Please see the attachment below.

Thanks,

AS

sundarakumar
Specialist II
Specialist II

Hi,

PFA example of Not eists.

-Sundar

vijetas42
Specialist
Specialist
Author

Thanks,not exists function is working fine

sundarakumar
Specialist II
Specialist II

You are welcome. Please Close the thread once u r done.

U can close it by marking the correct answer.