Alteryx Designer Desktop Discussions

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

How to Select all the .txt file from folder into a Input Data in the Alteryx Gallery

NBlancorodriguez
7 - Meteor

Hi,

 

I'm trying to file browse all the .txt files (from the Alteryx Gallery) merge into one input for example I can do it from the Designer using *.txt in the Input Tool, but I need this option for the user can select all the files from a folder. In the Alteryx Gallery only allow me to select one file.

 

NBlancorodriguez_0-1678987347280.png

 

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

Hi @NBlancorodriguez ,

 

if you are using the *.txt in the workflow it will find every .txt file in that folder (and sub-folders if selected), however, if you then use the interface tools to select the file on run, then it will only run for the file you select.

You can use the folder select tool in conjunction with *.txt, and then you can load in all .txt files within the selected folder structure. 

Alternatively, you can use the directory tool to pull all .txt files in the first app, then chain to the second app and populate a List Box tool:

 

mceleavey_0-1678991201183.png

 

This will require a chained app, and will allow the user to then check the files they wish to load.

 

You can learn more about Chained Apps at the following links:

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

https://community.alteryx.com/t5/Engine-Works/Dynamic-Hard-Coding-Chained-App-Sorcery/ba-p/764585

 

I hope this helps,

 

M

 



Bulien

NBlancorodriguez
7 - Meteor

@mceleavey ,

 

 

Thank you for your prompt response,

 

Do you have an example for this option: "You can use the folder select tool in conjunction with *.txt, and then you can load in all .txt files within the selected folder structure. "?

 

Regards,

Nicolas Blanco

NBlancorodriguez
7 - Meteor

I'm trying to apply this option to be available in Alteryx Gallery, but the folder browse doesn't work in the Web.

mceleavey
17 - Castor
17 - Castor

Hi @NBlancorodriguez ,

 

I've attached the following workflow:

 

mceleavey_0-1679000148362.png

 

This has a hardcoded value for the .txt file as follows:

mceleavey_1-1679000186895.png

 

The folder browse tool allows you to select a folder then overwrite a specific part of the string, in this case the folder path, leaving <folder path>*.txt.

 

This should allow you to do what you're trying to do, however the Folder Browse tool is not supported for deployment on the server.

 

 

M.



Bulien

Labels
Top Solution Authors