Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Variable incrementation

Pouchy
6 - 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?

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

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

Pouchy
6 - Meteoroid

Thank you very much !

Labels