Post reply

all matching records using Look Up component

  • January 8, 2009 at 5:17 am

    #129036

    Is there any method of retrieving all matching records using a Look Up Component?

  • January 8, 2009 at 12:02 pm

    #923608

    Just want to make sure I understand the question. The data that your lookup transformation is using has more than one matching row based on the join columns in the input pipeline? So if the pipeline has "Customer Number" of 123 the lookup data source has more than one row for Customer Number 123?

    If that is the case you might want to use a merge join transformation instead of a lookup.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply