Hello everyone!
Have to clear a query. I want to add a cycle number to the rows. Let me clear this with an example:
Flag | Cycle No. |
rdy | 4 |
st | 3 |
-- | 2 |
st | 1 |
rdy | 5 |
-- | 4 |
st | 3 |
st | 2 |
st | 1 |
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...
Any suggestions?
TIA!
Nancy
Solved! Go to Solution.
Hi @NancyS
I don't understand the sequence in your example:
Starting at 4:
rdy | 4 |
st | 3 |
-- | 2 |
st | 1 |
All of a sudden, you bring a new sequence starting at 5:
rdy | 5 |
-- | 4 |
st | 3 |
st | 2 |
st | 1 |
Could you be more specific or give a larger list of records so we could figure this logic out?
Cheers,
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.
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".
Nancy