Using a variable in the title of an output file

[Marie-Camille]

Hello,

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

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.

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

Thanks for your help !

[ShaanM · Accepted solution]

@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

[danilang]

@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]

@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

[Marie-Camille]

Hi,

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