Hi Everyone,
I'm trying to perform a lookup transformation. But the deal is, I have this one value that I am passing into the transformation, but I would like to gather all values that match the value I put in....does the lookup transformation do this? I tried it, and it appears as if it only returns one value for the one input. After the lookup, I have an access OLE DB destination setup...so I can capture all those values that corresponds to that one value I passed into the lookup. Does anyone have any ideas on how I can go about this?
Thanks!
Not quite sure what you want to do here. The LOOKUP works on a row at a time in isolation from all other rows.
Do you mean you want to return multiple values from your lookup cache? it doesn't do that, it only returns one value. The first one that it sees.
It sounds like you want to be looking at the MERGE JOIN component.
-Jamie
No comments:
Post a Comment