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
Solved! Go to 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
Perfect, thank you! So simple in the end :)