This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.