none
How to compare 2 values in different table and sources? RRS feed

Answers

  •  toongyang wrote:

     


    is it lookup component can compare two column from different table?

     

     

    In certain way, yes.

    The lookup transformation will allow you to join 2 tables based on a set of columns, in your case email field, then bring additional columns to the data pipeline from the lookup table. I recommend you to check Books on line.

    Notice that lookup can only based in tables that comes from an OLE DB source. If this is a problem for you, you could have 2 source components and then use a merge join. Merge join requires the 2 data sets to be sorted.


     

     

    Thursday, August 2, 2007 12:12 PM
    Moderator

All replies

  • Can you provide more details?

     

    What would be the filed(s) to be compared and which the ones to be updated?

     

    See if the 'Checking to see if a record exists and if so update else insert ' thread in the 1st page of this forum helps you.

     

     

     

    Wednesday, August 1, 2007 1:29 PM
    Moderator
  • ---------------------------------

    Contact1

    --------------------------------

    email                      ID

    abc@yah.com

    bbf@ya.com

     

     

     

    ----------------------

    Contact2

    ----------------------

    email                     ID

    abc@yah.com

    zzz@yaho.com

     

    i want to check whether email column in two table match or not?

    if got matching case, update the ID column in table Contact 1 with ID in Contact2

    (Expected result is abc@yah.com matching only)

     

    is it lookup component can compare two column from different table?

     

    thx.

    Thursday, August 2, 2007 10:11 AM
  •  toongyang wrote:

     


    is it lookup component can compare two column from different table?

     

     

    In certain way, yes.

    The lookup transformation will allow you to join 2 tables based on a set of columns, in your case email field, then bring additional columns to the data pipeline from the lookup table. I recommend you to check Books on line.

    Notice that lookup can only based in tables that comes from an OLE DB source. If this is a problem for you, you could have 2 source components and then use a merge join. Merge join requires the 2 data sets to be sorted.


     

     

    Thursday, August 2, 2007 12:12 PM
    Moderator