Post reply

Conditional Split Question (I think)

  • May 17, 2010 at 10:04 am

    #144710

    I have loaded a group of text files' data. However, I want to eliminate those rows where the value is equal to the those in a pre-existing table. Basically, it is like this:

    If textfile.inputcolumn = tblBadData.id_column then eliminate the row from the text file's data set. Can the conditional split transformation do this? I thought the conditional split only worked with functions.

  • May 17, 2010 at 10:12 am

    #1168345

    You could use a Lookup Transformation for this. Set the Lookup Transformation so that the lookup sucess (green arrow) does not go anywhere after the lookup and the failure condition (red arrow) routes your new rows into the destination. You'll need to set the error condition to redirect the rows that fail the lookup.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 17, 2010 at 11:25 am

    #1168372

    Agreed, I have done this a few time..

    CEWII

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

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