How to identify change in a column?

[ipazin]

Hello @Steve_Matthews,

well it’s far from evening win my time zone but hope it will be a good one

Regarding your task think I get it now. You are looking for a change in a single column. Maybe this topic can help you:

Assign group ID for rows

Hello all, is it possible to assign group ID to the row of a table without scripting as in the following example? Item GroupID A 1 A 1 A 1 B 2 B 2 B 2 C 3 C 3 A 4 A 4 D 5 B 6 B 6 C 7 C 7 C 7 D 8 D 8 D 8 Or, should I use a Java/R/Python script for that? Thank you in advance! Roland

There you’ll find my workflow with multiple approaches. Still providing input data and expected output helps forum users help you

Br,
Ivan