Combining Rows

Follow

Geoff

• February 07, 2020 20:43

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)

 

 

0

• 

  Gerry Mullin

  • February 07, 2020 22:13

  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

   

  0

  Comment actions Permalink

Please sign in to leave a comment.