community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Create Column with Repeating Numbers

Highlighted
Asteroid

Is there a simple way to repeat a range of values in a column? for example, if I want to number every row 1 through 18 in a new column and repeat that sequence all the way to the end what is easiest way to do this? 

 

Would it be a multi-row formula tool?

Alteryx Certified Partner
Alteryx Certified Partner
Yes it would be a multi-row formula tool, something like...

IF [ROW-1:FIELD] = 18 THEN 1 ELSE [ROW-1:FIELD]+1 ENDIF

This word be in the case you are generating a new column called "field" in the multi-row config.

Bem

Labels