Lookup Allowing dups..

[hcsccedi]

Hi All,

My requirement was ..
For example for iam doing lookup on COUNTRY field as below..

i/p
COUNTRY ITEM
------------ -------
X ds
Y sd


Reference
COUNTRY CODE
------------ ----
X 10
X 20
Y 10

o/p
COUNTRY CODE ITEM
--------- --------- ---------
X 10 ds
X 20 ds
Y 10 sd

I want to create new record for values having duplicates from reference dataset...

Does "ignore duplicates" option does this work or do i need to do any thing?

Thanks...

[HariK]

Lookup is supposed to return only one row from the reference input. If there are more than one record that matches it will throw warning

Join can be used instead.

[ray.wurlod]

Lookup is supposed to return only one row from the reference input. If there are more than one record that matches it will throw warning.

That's not true. One reference input to a Lookup stage is permitted to return multiple rows. There's a drop-down list that allows that link name to be selected.

[jseclen]

Hi Ray,

I check in the lookup stage and there isn't an option to define this features, and the plugin database is the same.

Can you tell us where is the option.

Thanks

[keshav0307]

"I want to create new record for values having duplicates from reference dataset"

What about unique records??