Is it possible to load several files with the "File Browse" tool over the Gallery ?

@ atcodedog05 - Is it possible to load several files with the "File Browse" tool over the Gallery ?

I receive several csv files with the same structure. I want to use i.e. the "Interface tools /File Browse" tool for this to manually upload these to the Gallery on my Alteryx Server for the blending/filtering workflow there.

Is it possible to upload more than 1 file like possible it is possible the "Input Data" tool (*.csv)

By now I can only select 1 file.

Developer

Accepted answers

All comments

Thableaus

Hey @Alteryx_Geek

The file browse tool looks specifically for one file in your folder structure.

You would have to use a Text Box interface tool and copy and paste the folder path, replacing the filename by the * wildcard. Then, make as an Action to update the value of the filepath in the Input Data Tool.

That's how I'd envision the solution.

Cheers,

amruthas2

Hi @Alteryx_Geek
If the naming convention is same you can use the below method - change the path with '*' , as you say the structure is the same it megers the files
have a look at the Message Tab and Input Configuration Tab for better understanding.

Please let me know if this helps

atcodedog05

Hi @Alteryx_Geek

I am assuming you are reaching out to me since I had built a solution like below before. And sadly the images are deleted

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/User-prompts-for-selecting-multiple-files-and-execute/m-p/656573#M151769

Since folder browse is not supported in Gallery we would need a workaround.

Here is how you can do it. What I am doing here I am asking the user to select a file in the folder where they want to read all files. And in the action tool I am changing the path so a path like C:\Users\atcod\Downloads\Files (1)\Files\Data\File A.xlsx|||`Sheet1$` will be changed to C:\Users\atcod\Downloads\Files (1)\Files\Data\*.xlsx|||`Sheet1$` this way it reads all the files.

Note: For this method to work all files should have the same format and should reference the same sheet.

Let me know if this works for you.

Hope this helps : )

Files reader.yxwz

Alteryx_Geek

Thanks will look into this and let you know

Alteryx_Geek

Thanks, I know this method works while running it from alteryx.

but I am looking to run it from gallery app

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703