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...
Lookup Allowing dups..
Moderators: chulett, rschirm, roy
Lookup Allowing dups..
HCSC CEDI Admin
Re: Lookup Allowing dups..
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.
Join can be used instead.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Lookup Allowing dups..
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.HariK wrote: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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Lookup Allowing dups..
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
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
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia