Add the textbox to the output file name

[radhikasood1112]

I am trying to add the user input value (through the textbox interface tool) to the name of the output file name.

For example the user enters -

Then the file should be saved as XYZ_DataFile.(where XYZ is appended to the filename)

Thanks,

Radhika

[atcodedog05]

Hi @radhikasood1112 

What is the type of output file? Is it excel?

Can you provide more info on this usecase. Is the output filename and path fixed? Is yes what is the format of the filename?

[atcodedog05]

-

[danilang · Accepted solution]

Hi @radhikasood1112 

There are a couple of ways to do this depending on the if the file name is fixed or variable 

If the file name is fixed, you can use an action tool to modify the File in the Output Data tool directly as in the top example.  If the filename is variable, connect the Text Input to the tool where the filename is defined

Dan

[atcodedog05 · Accepted solution]

Nicely done @danilang it was different from my usual approach. Hence was a good learning and getting a new perspective 🙂

Hi @radhikasood1112 

Let me also share my take on it.

Step - 1: Configure filename like below with prefix in the filename.

Step - 2: Replace prefix text in the action tool.

This should work with any type of file format and should be flexible.

Hope this helps : )

[radhikasood1112]

The filename and the path to store the file is variable.  Example for the filename - 

XYZ_DataFile.hyper or XYZ_DataFile.csv. XYZ=client name provided by the user.

DataFile is fixed.

[atcodedog05]

Hi @radhikasood1112 

Are you using file browse interface tool to ask user where to save it?

[radhikasood1112]

Yes - textbox interface tool

[atcodedog05]

Hi @radhikasood1112 

Can you check the above solutions does those work for you. If not, can you tell us why not?

[radhikasood1112]

Thank you for the help. The UserPrefix is working. However, if I combine this workflow with the other workflow - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Use-interface-tool-to-select-the-locat... it doesnt work.