Increase date by 1 year and copy data

Question

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:

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

Could someone assist me with this?

Thanks!

Outcome.xlsx

Sample.xlsx

OTrieger · Answer

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

AneeshPandey · Answer

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

OTrieger · Answer

@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?