Shifting month value to another month

[ankitgupta]

Hi all , I need some help in solving this, I have a column with data 

YearMonth	Value
201801	10
201802	20
201803	30
201804	40
201805	50

I want output as 

YearMonth	Value	Value1
201801	10
201802	20	10
201803	30	20
201804	40	30
201805	50	40

Thanks,

[jamielaird · Accepted solution]

Hi @ankitgupta 

You can use a Multi-Row Formula tool for this, using the expression:

[Row-1:Value] 

to create the value for a new field named Value1 by taking it from the row above.

For more on the Multi-Row Formula tool see this article:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603