Shifting month value to another month

Question

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

YearMonthValue2018011020180220201803302018044020180550

I want output as

YearMonthValueValue120180110 2018022010201803302020180440302018055040

Thanks,

jamielaird · Accepted Answer

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