Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.