How to Select all the .txt file from folder into a Input Data in the Alteryx Gallery
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Gallery
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to apply this option to be available in Alteryx Gallery, but the folder browse doesn't work in the Web.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @NBlancorodriguez ,
I've attached the following workflow:
This has a hardcoded value for the .txt file as follows:
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.
