Hi all,
I need some clarification in assigning the value:
Input file :
Column1
BB
CC
CC
BB
CC
Lookup file:
Column1 column 2
BB 34
CC 23
CC 45
CC 12
So i need to assign the column 2 value for each records ,there is only one column 2 value for BB record in the lookup file,i need to assign the value for one record , so another record in input file needs to send as reject record.
How can i assign the value? and get the reject record.
Please help me to solve this.
Thanks in advance.
To get reject record
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: To get reject record
Hi,ithirak_17 wrote: there is only one column 2 value for BB record in the lookup file,i need to assign the value for one record , so another record in input file needs to send as reject record.
.
If I understand your post correctly, You problem is more related to rejection of duplicates, rather than with the lookup.
There are some posts here on rejection of duplicates. Let us know if you need more details.