Lookup stage question

pavan_test · Post by **pavan_test** » Mon Sep 17, 2012 9:33 am

I am using lookup stage (lookup failure : continue). I have a main link and reference link. I can't switch the main link to reference link.

input col ID: (main link)

223
223
223
223

reference link:

223 A
223 B
223 C
223 D

lookup failure = continue in lookup stage

current output:

223 A

desired output:

223 A
223 B
223 C
223 D

can someone please advice,

Thanks
pavan

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2012 2:47 pm

Enable return of multiple records from the reference input link.

Kryt0n · Post by **Kryt0n** » Mon Sep 17, 2012 4:16 pm

Or alternatively, if you are actually trying to switch your links around from the descriptions and make the A,B,C,D input your main link, disconnect one of the links first, then on each link, right click and Convert to ... (Reference for current stream/Stream for current reference), then re-connect. You will have to re-join keys etc

pavan_test · Post by **pavan_test** » Sat Sep 22, 2012 6:39 pm

Enable return of multiple records from the reference input link resolved my problem.

Thanks
pavan