Post reply

Process a row two different ways

  • October 8, 2008 at 12:50 pm

    #131702

    Hi all,

    I'm using a script compoent (as a transformation) inside my data flow to attempt to process a row two different ways, but I'm not sure if i'm going about this the right way. here are the details:

    My script component has one input and two outputs. I'll call the outputs ScrubA and ScrubB. ALL rows will get processed through ScrubA and only certain rows in ScrubB (both by later tasks). What gets redirected to ScrubB is basically determined by if ColumnA <> ColumnB for each row.

    My issue is if ColumnA <> ColumnB the row will get redirected so it will no longer be in ScrubA. I want

    the row to stay in SbrubA and a copy of that row to go into ScrubB.

    Can this be done in the script component? Or should I be using a different task to accomplish this?

    Thanks,

    Strick

  • October 8, 2008 at 12:59 pm

    #882527

    You may try the Conditional Split or Multicast Data Flow Transformations (or a combination of both).

    John Rowan

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

  • October 8, 2008 at 1:12 pm

    #882537

    That's just it. Conditional split will do the same thing. It will move a row to one flow or the other based on the condition. I need ALL rows to go through outputA and some of the rows go to OutputB based on the condition.

    example:

    Column1,Column2

    This, That

    is, is

    a, no

    test, test

    So in this example I want all 4 rows to go thorugh outputA and only 2 rows (row 1 and row 3) will go to outputB. A conditional splits sends it through one flow or the other.

    Thanks,

    Strick

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

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