Hi All,
I want to figure out the way to add a count number to transactions.
id | Transaction status | Count Number |
1 | Start | 1 |
1 | in_between | 1 |
1 | in_between | 1 |
1 | end | 1 |
1 | start | 2 |
1 | end | 2 |
1 | start | 3 |
1 | start | 4 |
1 | start | 5 |
The problem I'm facing is I can't use group by in summarize tool to achieve this. Any other way around?
TIA!
Solved! Go to Solution.
Hi @AlterCom
You can use a Multi-row tool configured like this
Every time it comes across the word "start" it increments the count. if the Trans status isn't "start", it uses the count from the previous row. See Attached WF
Dan
Thanks @danilang !