Hi Mike,
Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 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.
How to Achieve this Logic?
Moderators: chulett, rschirm, roy
Hi Mike,
Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 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.
Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 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.
Hi Mike,
Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 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.
Number amount currency Code CustID Address
123456 10.00 22 21 123 London
123456 10.00 22 11 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.