How to find out what is in list 2 but not in list1

Champa · Post by **Champa** » Sun Sep 24, 2006 4:25 pm

All,

I have two lists from 2 oracle stages. I want to know how to find out what is in list 2 but not in one. Can you please let me know how to do that.

Thanks

anntaylor · Post by **anntaylor** » Sun Sep 24, 2006 7:57 pm

You could have list 1 be a lookup and have the unmatched keys go to a reject link for processing.

vmcburney · Post by **vmcburney** » Sun Sep 24, 2006 8:07 pm

Use a transformer stage accepting both sources as input with list 2 as primary input and list 1 as a reference lookup. Join on all fields, if you have a unique primary key you can just join on those fields for faster processing. Have a single output with a constraint of list1.NOTFOUND. This will output any rows from list 2 that were not found on list 1.

sb_akarmarkar · Post by **sb_akarmarkar** » Sun Sep 24, 2006 11:20 pm

Outer join in user-defined SQL .....

Thanks,
Anupam

ray.wurlod · Post by **ray.wurlod** » Mon Sep 25, 2006 1:19 am

Where are the lists once you've retrieved them from Oracle? If you write the lists of keys into two files in the &SAVEDLISTS& directory (using Sequential File stage), then you can use the LIST.DIFF command to ascertain the difference.