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

Alteryx designer Discussions

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

Variable incrementation

Highlighted
Meteoroid

Hi everyone,

 

This might be a stupid question, but I have this :

 

4.PNG

 

I just want a new column, starting from 0, and each time there is a 1 in "New Field", I want to increment my variable (+1).

So for the picture above, I want 1 from 01/01 to 07/01, then 2 from 08/01 to ...

 

I try "Generate rows" but it doesn't seems to work.

 

Any ideas?

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Pouchy 

 

Use Multi-Row Formula Tool - (no group by checked)

 

IF [New Field] = 1 THEN [Row-1:Variable] + 1

ELSE [Row-1:Variable]  ENDIF

Meteoroid

Thank you very much !

Labels