Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Frequency Table Report - Dynamic Location/Name

cca8380
7 - Meteor

is there a method for assigning a dynamic name and location for the Frequency Table report?

5 REPLIES 5
alexnajm
17 - Castor
17 - Castor

Can you clarify the question a bit further?

cca8380
7 - Meteor

I would like to save to frequency table report to a network drive and append the date to the end of the report name dynamically. 

alexnajm
17 - Castor
17 - Castor

Sure! An Output Data tool would do the trick to output the data to the network location, but beforehand you can create the FileName with a Formula tool. This article details a similar situation: Dynamic file name and sheet name in output data - Alteryx Community

 

The key things here are 1) using the Formula to create the FilePath with the date (assuming DateTimeToday) and 2) selecting the "Take File/Table Name" at the bottom and configuring it properly.

cca8380
7 - Meteor

I would like to save the frequency table report to a network drive and append the current date to the end of the report name dynamically. 

alexnajm
17 - Castor
17 - Castor

The article above should provide enough guidance to complete this! Without sample data and the network drive location, it'll be hard to replicate on our end.

Labels