ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

How to create a workflow to create table names dynamically at the beginning of each year

5 - Atom


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.

14 - Magnetar

Hi @SCR ,


Just a heads up that the best place to post this is the Alteryx Designer Discussions forum:


This forum is for posts on the Analytics Hub.