How do I create a column with each two rows lines numbered 1,2?

[PDempsey]

I need to add a column to my workflow (accounting related) which reads as follows:

1

2

1

2

1

2

1

2

and so on

I have tried using:

IF ([ROW-1] % 2 = 0 THEN 2 ELSE 1 ENDIF) and other versions of this but it seems my alteryx won't execute any expression containing [Row-1] or [RowID] etc.

Any help greatly appreciated , thanks in advance

[davidskaife · Accepted solution]

Hi @PDempsey 

Try this, create the column you want to have the numbering on and fill it with 1, then use the Multi-row Formula tool with this expression:

IF [Row-1:Accounting] = 1 
then 2 
else 1 
endif

[PDempsey]

Perfect, thank you! So simple in the end :)