Page 1 of 1
Warning in lookup stage
Posted: Sun Aug 12, 2007 6:17 am
by parag.s.27
Can some one tell me why is this warning comming in the lookup stage.
Code: Select all
Lookup_123: When checking operator: Dropping component "UNDERWRITER" because of a prior component with the same name.
I tried searching in the forum, but could,nt get any link
Posted: Sun Aug 12, 2007 6:35 am
by JoshGeorge
Search on keywords "prior component with the same name". Try disabling RCP.
Posted: Sun Aug 12, 2007 11:47 pm
by Maveric
In the Lookup stage the field names of the lookup keys should be the same and the other fields (in Reference and main link) should be unique. Like JoshGeorge said try disabling RCP or rename one of the fields.
Posted: Tue Aug 14, 2007 6:18 pm
by samu
You will get this error when you have the same column names in the input, reference and output links. As maveric said try to rename the outputs coming from reference link differently or if you don't need any data coming from the reference links try to delete the columns that are not key columns.
Example1:
Input:
Col1 (Key)
Col2(Key)
Col3
Col4
Reference:
Col1 (Key)
Col2(Key)
Col3
Col4
Output:
Out1 (map) -------- Col1 ( from Input)
Out2 (map) -------- Col2 ( from Input)
Out3 (map) -------- Col3 ( from Input)
Out4 (map) -------- Col4( from Input)
Out5 (map) -------- Col3 ( from Reference)
Out6 (map) -------- Col4( from Reference)
Example2:
Input:
Col1 (Key)
Col2(Key)
Col3
Col4
Reference:
Col1 (Key)
Col2(Key)
Output:
Out1 (map) -------- Col1 ( from Input)
Out2 (map) -------- Col2 ( from Input)
Out3 (map) -------- Col3 ( from Input)
Out4 (map) -------- Col4( from Input)