lookup warning

bharatmajeti · Post by **bharatmajeti** » Fri Apr 04, 2008 4:21 am

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.

Klaus Schaefer · Post by **Klaus Schaefer** » Fri Apr 04, 2008 5:00 am

Since you seem not to want duplicate matches, you should deduplicate your reference data with the remove duplicates stage.

Klaus

priyadarshikunal · Post by **priyadarshikunal** » Fri Apr 04, 2008 6:17 am

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.

bharatmajeti · Post by **bharatmajeti** » Mon Apr 07, 2008 2:55 am

thank you Priyadarshi Kunal, with your advice i solved the problem

ray.wurlod · Post by **ray.wurlod** » Mon Apr 07, 2008 3:02 am

Then would you please, as originator, mark the thread as Resolved?

DSXchange

lookup warning

lookup warning

Re: lookup warning

Re: lookup warning