community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

Asteroid

Hi all

 

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. 

 

I can't use a shared folder to upload the files where the Alteryx server can read the files from.

 

Many thanks for your answers

 

Steffen

Alteryx Certified Partner
Alteryx Certified Partner

Yes.  Why not use a FOLDER browse and then concatenate *.csv to it?

 

Formula would look like:

 

[#1] + "*.csv"

That will take all of the contents of the folder that are csv for input.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid
Hi Mark

OK I will try this. But I thought it is not supported. (like written in the description of the tool).
Or ist this only for the Analytics Gallery in the Internet?

Kind regards
Steffen
Alteryx Certified Partner
Alteryx Certified Partner

@vizda,

 

If you use a single file browse, a formula like the one below will replace the selected file with all csv files:

 

REGEX_Replace([#1], "(.*\\).*$", '$1') + "*.csv"

it will capture the path and choose *.csv.

 

Please try that and let me know how it works for you.

 

Cheers,

Mark

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Asteroid

Hi Mark

 

unfortunately it doenst work on the server.

 

When I try it locally as app it runs fine. But when I use it over the web gallery it doesnt work.

My workflow is attached.

When I specify a file in the input data tool it uses only this file.

When I use there a *.csv I get an error message "file cannot be found...."

 

It would be fine if you find a solution

 

Kind regards

Steffen

 

Steffen

 

 

Labels