Increase date by 1 year and copy data

[AneeshPandey]

Hi,

I'm having trouble creating a workflow in Alteryx and would appreciate some help. I have an Excel file named "sample" that contains data for the year 2032. I need to:

1. Copy the data for 2032 and increment the year to 2033.
2. Modify any rows with the date February 29, 2032, so that they read February 28, 2032.
3. Save the modified data to a new Excel file named "outcome."

Could someone assist me with this?

Thanks!

[OTrieger]

@AneeshPandey what have you done so far and what is the challenge?
From your familiarity so far with Alteryx, which tool do you think that you might need to use?

[AneeshPandey]

I have added the rows using datetimeadd and generate rows, however cant figure out how to copy the data into the rows. 

[OTrieger]

Can you please share a snippet of the Results window to show how the data is looking after what you did so far