Hi,
i got the following warning regarding a lookup stage.
Warning:Med_Paid_lkp,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table
Lookup stage is having a main link and reference link among which the records in main link are unique with respect to the looking up columns. reference link records are not unique with respect to the looking up columns.
ofcourse my data is coming correctly, i want to ask, is there any way to hide this warning.
lookup warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Mon Feb 18, 2008 7:28 am
lookup warning
Nothing but something
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
Re: lookup warning
Since you seem not to want duplicate matches, you should deduplicate your reference data with the remove duplicates stage.
Klaus
Klaus
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: lookup warning
If you don't want duplicates in the reference link then remove the duplicates.
Else if it is necessary to bring all the entries to the lookup reference link you should allow multiple records in the lookup reference link.
in constraint window you can see a drop down menu with heading
"Multiple records returned from" (or something similar)
in that select the reference link.
Else if it is necessary to bring all the entries to the lookup reference link you should allow multiple records in the lookup reference link.
in constraint window you can see a drop down menu with heading
"Multiple records returned from" (or something similar)
in that select the reference link.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 13
- Joined: Mon Feb 18, 2008 7:28 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: