Using a variable in the title of an output file

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 !

Output

Accepted answers

ShaanM

@Marie-Camille

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

All comments

ShaanM

@Marie-Camille

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703