Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Load all the sheets of a file at once in 'File Browse'

Sousou
8 - Asteroid

Hello Community,

 

I would like to add all the sheets of a file at once, currently I use 3 "File Browse" to select the 3 sheets of the same file.

Is it possible to exploit all the sheets of a file with a single File browse?

Like this:

 

exceltest.PNG

excelsheets.PNG

 

thank you in advance for your help

13 REPLIES 13
Sousou
8 - Asteroid
Oh yes sorry i don’t think about it :p, i will try then i will get back to
you.

Thank’s a lot ! :)
Sousou
8 - Asteroid

Hello @DavidP

 

How are you ?

Your workflow is exactly what i want, in the designer interface, everything is perfect but i can't use in Alteryx server, i have this message but i don't know why ? do you think it's linked to credential access on my computer?

error.PNG

Have a nice day

 

 

DavidP
17 - Castor
17 - Castor

I don't currently have server, so I can't replicate the problem. One strange thing I noticed is that I would expect to see 3 pipes (|||) between xlsx and <List of Sheet Names>

 

Is this the file you're trying to load with the File Browse tool?

Sousou
8 - Asteroid

Yes @DavidP it's the file uploaded with file browse in the Alteryx Server Gallery, it's strange... maybe i have to change something in my workflow dependencies.. or in the parameter of Alteryx Server, cause Alteryx server is installed on a specific machine..