Alteryx Designer Discussions

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

Using a variable in the title of an output file

Marie-Camille
5 - Atom

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 !

4 REPLIES 4
ShaanM
Alteryx Alumni (Retired)

@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

Shaan Mistry
Co - Founder : datacurious.ai
danilang
18 - Pollux
18 - Pollux

@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

ShaanM
Alteryx Alumni (Retired)

@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

Shaan Mistry
Co - Founder : datacurious.ai
Marie-Camille
5 - Atom

Hi,

 

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

Labels