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.  expanding a list - how?

    Employee
    Posted 06-17-2016 10:59

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

    Originally posted by: james

    I have a file with thousands of rows
    Each row (record) has several fields
    Two of the fields indicate a range - the "start" and "end" value of a range.

    I want to create a new record for each value in that range.

    current data
    data-1 start-range end-range
    --------- ------------ -----------
    aaaaa 1 3
    aaaaa 23 25


    desired result
    data-1 range-value
    --------- ------------
    aaaaa 1
    aaaaa 2
    aaaaa 3
    aaaaa 23
    aaaaa 24
    aaaaa 25

    Does anyone have a code solution for this?


  • 2.  RE: expanding a list - how?

    Employee
    Posted 06-17-2016 12:56

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

    Originally posted by: ryeh

    Check the attached. There's an "Expand from List" node. The trickier part is to build the list.

    I've also included a second option that uses a 'do output' within a while loop.
    Attachments:
    ExpandFromList.brg