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?
Use Not exists in load script.
PFA example of Not eists.
Thanks,not exists function is working fine
You are welcome. Please Close the thread once u r done.
U can close it by marking the correct answer.
This can be acheived by Lkup function . Please see the attachment below.
Retrieving data ...