Looping through data set

[tomnorth94]

Hi,

Here is my problem which I'm trying to automate using alteryx!

Using my pictures as a reference, I want to take the data set in picture 1 and transform it into picture 2. Essentially, I want the data to be able to move in time, i.e. if the reporting date flicks forward a month, then my data will move forward by one month too. 

So I want a workflow that will take the reporting date in pic 1 (i.e. May 2018), then add on a month (like in picture 2). My time series column for June 2018 will now exclude May 2018 and include August 2018. My revenue data will now shift by one cell accordingly. 

Is this possible to do in alteryx?

If so, would really appreciate some help!

Cheers,
Tom.

[ponraj · Accepted solution]

Yes. This is possible in alteryx.  Attaching a sample workflow for your case...

[tomnorth94]

Thank you very much!!

[tomnorth94]

Next question, how can I make this repeat/loop more than one time? 

i.e. repeat for the next 12 months. 

[ponraj]

Possible to give sample data with desired output ?