To get reject record
Posted: Tue May 12, 2009 8:48 am
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.
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.