Unmatched values problem

[vijetas42]

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?

[sundarakumar · Accepted solution]

Use Not exists in load script.

-Sundar

[amit_saini]

Hi Vijeta,

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

Thanks,

AS

[sundarakumar]

Hi,

PFA example of Not eists.

-Sundar

[vijetas42]

Thanks,not exists function is working fine

[sundarakumar]

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

U can close it by marking the correct answer.