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..