Help with to create new rows

[kailash85]

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

[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 · Accepted solution]

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]

Thanks so much! that was quick!