Add a count number to transactions

Question

Hi All,

I want to figure out the way to add a count number to transactions.

idTransaction statusCount Number1Start11in_between 11in_between11end11start21end21start31start41start5

The problem I'm facing is I can't use group by in summarize tool to achieve this. Any other way around?

TIA!

danilang · Accepted Answer

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