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 Designer Discussions

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

How to Export a file using a field as the naming convention

jdelaguila
8 - Asteroid

Hi Alteryx Team!

 

I want to to be able to Output a .xlsx file and use the naming convention from a field in the data. 

 

In my attached workflow i have a simple input with a field called [FILENAME]. I want to be able to output the file as [FILENAME].xlsx

 

So basically whatever is populated in FILENAME is the name of the file.

 

I can't seem to get it to work using the attached workflow. Can anyone help?

 

Thanks!

Javier

 

 

pedrodrfaria
13 - Pulsar

HI @jdelaguila 

 

I updated your workflow to consider the filename column as the correct file name. I used the formula tool to create the file path.

 

This is my preferred method to use data info as the name of the file for when outputting to a xlsx.

 

If you were trying to output to a CSV, the set up you were using was the correct one, would just need to change the file extension.

 

Pedro.

jdelaguila
8 - Asteroid

Thank you sooooo much! You literally solved my problem within 5 min of me posting this. Gold STAR!!!

 

Javier

Labels