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

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!

Yearly Growth.xlsx

Workflow

Help

Accepted answers

john_miller9

@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

MultipleRow.yxmc

MultipleRow.yxmd

All comments

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.

MultipleRow.yxzp

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!

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!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167