Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

How to remove dynamic file path in output file

Sashankbongu
7 - Meteor

Hi Team ,

 

How can I stop including the file path in the output file when using dynamic file name.

Unchecked the option "Keep field in output" but still visible in the data.

Thanks much.

 

altery output file path.png

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @Sashankbongu,

 

You got two columns file name and file name 2. I think you will not be able to remove the second one using the tool.


If you are using called file_name to get an output location maybe you can use the select tool before the output file to remove file_name_2 from the file. 

Sashankbongu
7 - Meteor

@Emil_Kos 

The 2 file names are as I have to out put files/formats . 

I use File_Name for .csv and File_Name_2 for .yxdb. 

 

There is no problem with dynamic files names but the file path appears in the data as in the excel screenshot . I do not need this. 

alteryx output.png

Thanks,

Sashank

Emil_Kos
17 - Castor
17 - Castor

Hi @Sashankbongu,

 

I have created a perfect picture to show you what you need to do 🙂

 

Emil_Kos_0-1600336925308.png

I am joking it is a mess... 🙂 In short you need to have 2 select tools one for each of the files. 

In each of them you need to keep only the path for one of the files and then it will start working!

Sashankbongu
7 - Meteor

You are awesome mate, thanks

Labels