DSXchange

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

Enable return of multiple records from the reference input link.

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

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

Thanks
pavan