Help with to create new rows

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/2019	1
31/12/2019	3	30/11/2019	3
31/01/2020	5	30/11/2019	5
		31/12/2019	0
		31/12/2019	1
		31/12/2019	3
		31/01/2020	0
		31/01/2020	0
		31/01/2020	1

Sample.yxmd

Developer

Accepted answers

BrandonB

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

Tile Multi Formula workflow.yxmd

All comments

fmvizcaino

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

Please explain the details of your requirement

BrandonB

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

Tile Multi Formula workflow.yxmd

kailash85

Thanks so much! that was quick!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335