topic Re: How to add cycle number to a row in Alteryx Designer Desktop Discussions

How to add cycle number to a row

NancyS — Sun, 05 May 2019 17:50:44 GMT

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-on-a-condition-in-Alteryx/m-p/410650

Any suggestions?

TIA!

Nancy

Re: How to add cycle number to a row

Thableaus — Sun, 05 May 2019 18:05:11 GMT

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,

Re: How to add cycle number to a row

jamielaird — Sun, 05 May 2019 18:15:13 GMT

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.

Re: How to add cycle number to a row

NancyS — Thu, 09 May 2019 11:03:20 GMT

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