Count Grouping in Retain Change

[kritsapatw]

Hi everybody,

I have some question about grouping/ranking Node. I tried to design and hard to think about it but it not compute result on my answer. Anyway I have example data from excel to you. Pls helps me.

Ref. figure. I need label grouping of data changing from column B in column D and running grouping in Column C

datatest.xlsx (9.1 KB)

Many Thanks.

[ipazin]

Hello @kritsapatw,

here are tow possibilities:

• inside Group Loop use Lag node, Rule Engine, Manual Aggregation (see here)
• scripting (as always)

Give it a try and if any issues I can make example flow

Br,
Ivan

[kritsapatw]

Many Thanks, Ipzin.

I tried to your suggestion

it can correctly results.

[ipazin]

Glad to hear that @kritsapatw
Ivan