Post reply

lookup unmatched data

  • August 17, 2011 at 4:44 pm

    #243348

    I have 2 tables TableA and TableB,

    TableA: ColA_ID, ColB, ColC consists of 150 rows

    TableB: ColD_ID, ColE consists of 20 rows.

    Using Lookup transformation:

    I am looking up the data in TableB with ID column in both tables for ColE, Lookup matched rows will be 20 rows of resultset. But I want the Unmatched data in TableB as Null or Blank for the rest of a30 rows.

  • August 18, 2011 at 1:25 pm

    #1370343

    In your "Lookup" transformation, you need to "Configure Error Output..." to "Ignore Failure" for the lookup error.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • August 18, 2011 at 8:07 pm

    #1370497

    I used Fuzzy Lookup for this work. It gave me expected result.

    thanks for reply

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

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