Not sure how to describe the method/outcome, but what I need would be to generate a table like below. So let’s say we have a date column and a value with it, I’d like to have a ‘Rank’ that restarts every time the new row is different from the previous row. Any ideas would be greatly appreciated.
I’ve tried the rank node and looping with ‘Moving Aggregation’, but no luck so far.
Use the “Lag” + “Rule Engine” + “Missing Value” nodes to determine, whether the current row changes its value compared with the previous one and to create groups of consecutive rows
Use a “Group Loop Start” with some inner nodes to do the numbering for each group
