Hello everyone!
Have to clear a query. I want to add a cycle number to the rows. Let me clear this with an example:
One turn starts at first "st" and ends at "rdy". I want to add a cycle no. to it. that re- starts at next turn (when first "st" occurs (startof turn) "rdy" (end of turn).
This post is linked to the question: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-recognise-values-in-cells-based-on-a-condition-in-Alteryx/m-p/410650
Any suggestions?
TIA!
Nancy
Hi @NancyS
I think this should do what you're looking for:
This first numbers in ascending order, restarting for each Rdy row, then numbers each group, incrementing by one for each Rdy row, then calculates the max Cycle No per group in order to reverse the numbering.
I don't understand the sequence in your example:
Starting at 4:
All of a sudden, you bring a new sequence starting at 5:
Could you be more specific or give a larger list of records so we could figure this logic out?
Cheers,
Thanks @jamielaird , used a logic similar to yours for the implementation.Skipped the summarise tool,instead of assigning incremental numbers for "St" , assigned the very first "st" in each cycle the value of "1".
