LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Inserting Rows into an existing data set

    Employee
    Posted 09-20-2010 16:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jodycrutchfield

    I have 2 data sets
    set 1:
    1 a 3 1
    1 b 3 2
    1 c 3 3

    set 2:
    2 h 4 1
    2 j 4 2
    2 k 4 3

    I want to insert set 2 into set 1 after the row where column 2 = b.

    my final set should be:
    1 a 3 1
    1 b 3 2
    2 h 4 1
    2 j 4 2
    2 k 4 3
    1 c 3 3

    Is there a simple way to do this without writing a custom python node?

    Thanks,

    Jody


  • 2.  RE: Inserting Rows into an existing data set

    Employee
    Posted 09-20-2010 21:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: spatten

    Jody

    I have attached a solution that adds indexes to your data sets based on the condition then does a stable sort.

    Sam
    Attachments:
    InsertBlock.brg


  • 3.  RE: Inserting Rows into an existing data set

    Employee
    Posted 09-20-2010 22:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jodycrutchfield

    Thanks, I had not used the stable sort yet.