Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 234 Chennai
Address Table
CustID Address
123 London
234 Chennai
I have to findout duplicate based on Number ,amount,currency columns
and if code starts with 2 and populate corresponding address.
Else if code column start with 1 then populate code starts with 2 Address value.
The above is exact logic im trying.
Where as Address values are in different table and Im taking as lookupset in a job.
Stage Variable Declare
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How is this new question different from this question?
Do you have any idea how annoying being asked the same question multiple times is?
Do you have any idea how annoying being asked the same question multiple times is?
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.