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
How to find out what is in list 2 but not in list1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.