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

SCR
5 - Atom

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.

jamielaird
14 - Magnetar

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.