How to duplicate a row multiple times and each time shift data to the right?

[Justin_M]

Hi Community,

Wondering if someone could help me duplicate the yearly values for 5 times, and each time, shift the yearly value forward a year.

Attached the spreadsheet, "input" tab has what I got, "output" tab is what I want to achieve.

Thank you in advance!

[john_miller9]

See the workflow below that contains an iterative macro to produce the results.  I'm sure it could be improved to eliminate the first union, but this should get you there.

[Justin_M]

Thank you for helping me on this, John. However, I'm having trouble importing your workflow. I received the following error message:

"Failure to Import C:\Users\Downloads\MultipleRow (1).yxzp.
There was an error opening "C:\Users\Downloads\MultipleRow (1)\MultipleRow.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx."

I checked my Alteryx version, and it's up to date, version 2019.1.6.

Is there something particular about this workflow that prevent me from importing it into my Alteryx designer?

Thanks ahead!

[john_miller9 · Accepted solution]

@Justin_M  The newest version of Alteryx is 2019.2, which is the version the workflow and macro were made in.

I've saved them as 2019.1 for you and attaching here.  Let me know if this version works for you.

John

[Justin_M]

Never mind, John, I figured out how to open your workflow. However, once I open the workflow, the solid blue circle became a square with a question mark, and break from the rest of the workflow. Could you tell me how to find that particular tool, and what should I do with it? Or is there a walk-around not using that tool.

Sorry for the trouble. Thanks ahead!

[john_miller9]

@Justin_M 

You should save the macro (the .yxmc file) where your macros are located.  If you aren't sure, in the menu toolbar select Options > User Setting > Edit User Settings and select the Macros tab.