community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Using a variable in the title of an output file

Hello,

 

I'm trying to export Excel files with these options:

Alteryx.PNG

 

I have two different "BU" (named "NORD" and "SUD"), so I'm expecting to have two different files; one named "Validation NORD" and one named "Validation SUD". But it doesn't work; the title remains "Validation" in both cases, so the file with the first BU is erased by the one with the second BU.

File.PNG

How can I do to use the name of each BU in the titles of the files ?

 

Thanks for your help !

Alteryx
Alteryx

@Marie-Camille

 

Hi

 

you will need to select the option change entire file path.

 

There is a good guide here on how to set it up : https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Output-to-separate-Excel-files/ta-p/1247

 

Shaan

Nebula
Nebula

@ShaanM shows the way for excel files, but @Marie-Camille, your method works for .csv files.  A new file gets created every time the value in the suffix field changes.  

 

@ShaanM:  Is there a specific reason for the difference in behaviour when writing to Excel as opposed to other file types?

 

Dan

Highlighted
Alteryx
Alteryx

@danilang

 

that is correct @Marie-Camille method will work for csv files.

 

The main difference is that excel files have file name and table/sheet names, csv just have filename.

 

Alteryx can happily change the csv file name using the change file/table name option. But for Excel this option will only change the sheet name. That is the main reason why we are then required to change the entire file path to get around this.

 

Hope this clarifies

Hi,

 

I tried both methods (for csv and Excel) and they worked, thanks a lot to both of you !

Labels