Data360 Analyze

 View Only

  • 1.  Combining Rows

    Posted 02-07-2020 13:44

    Im stuck.... so I have a set of data, where there may be duplicates.. I need to combine them in a certain way.

    below is a "sample"

    I always need combine row 1 and 2, keeping the data in row 2. if present

    If something is in both rows for F1 it needs to NOT combine (manually review) (green output)

     

     



  • 2.  RE: Combining Rows

    Employee
    Posted 02-07-2020 15:13

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

    If you know you'll only have 2 rows in each group then it shouldn't be too hard to clean it up like that, using node.firstInGroup and node.lastInGroup functions. Have a look at the LNA attached.

     

    Attached files

    Group SRC - 7 Feb 2020.lna