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