To get reject record

[ithirak_17]

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.

[ray.wurlod]

Use a Merge stage, which consumes each row used from the reference (update) input.

[Pagadrai]

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.
.

Hi,
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.