Add new row and data rollover from last quarter is required

Question

I have attached excel where I want data in Column B every quarter which is different input file and Values of column B should be rolled to Column C in same sheet.

Meaning current quarter values should be in Column B and rest quarters should be after that in C,D,E like this.

Not sure if it is possible in Alteryx or not.

Can someone help me with this?

To explain further:

I want data in Column B every quarter when we run Alteryx. And data in Column B Should be shifted to Column C of previous quarter.

Eg:

Column B has data of July

Column C has data of April

When we run Alteryx for month of Sep then it should be in below columns

Column B - Sep

Column C - June

Column D - April

Book2.xlsx

CoG · Answer

What does your input look like specifically (do you have 2 inputs: one with the new column data, and another with the data to be shifted)? And are you overwriting columns at the end of the process or are you continually extending them? (e.g. next quarter would then push data to Column E then F, etc.)

If you have all the data from previous quarters, adding a new column in Alteryx to that table is not hard.

Meghnagupta · Answer