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

Help with to create new rows

kailash85
6 - Meteoroid

Hi, im very new to alteryx. Im trying to do something like the below. Im trying to use the multi filed formula but cant seem to figure it out. Can anyone help please? I managed to get as far as the attached workflow (getting an error on the IF statement)

 

thanks!!

 

Tabel1 Table2 Output 
30/11/2019 1 30/11/20191
31/12/2019 3 30/11/20193
31/01/2020 5 30/11/20195
    31/12/20190
    31/12/20191
    31/12/20193
    31/01/20200
    31/01/20200
    31/01/20201
4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @kailash85 ,

 

So the idea is, for each month you add to your data, you subtract 2 from your URR? Is that it?

 

Best,

Fernando Vizcaino

gautams091
7 - Meteor

Please explain the details of your requirement

BrandonB
Alteryx
Alteryx

Tile Multi Formula.png

 

That was a fun one! I used the tile tool to determine a tile number and sequence to then leverage a multi row formula. Workflow is attached and this is the formula that I used. 

 

IF [Tile_Num]=1
THEN [URR]
ELSEIF [Tile_SequenceNum]<[Tile_Num]
THEN 0
ELSE [Row-4:URR]
ENDIF

kailash85
6 - Meteoroid

Thanks so much! that was quick!

Labels