DSXchange

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.

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

Klaus

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.

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