Hello,
I was trying to automate a process I am running for every month. The monthly data append to a table called "Monthly Data". The report will run for the previous month's data each time. This table should only show current year's data. But I need to archive previous year's data before running next year. Here I had final run for 2020 data in January 2021. Now I need to archive this with table name "2020 Data" and delete all the rows from "Monthly Data".
Please see the workflow attached for the sample tables.
Hi @SCR ,
Just a heads up that the best place to post this is the Alteryx Designer Discussions forum:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions
This forum is for posts on the Analytics Hub.