How to insert an Excel file with multiple sheets as an input via Alteryx Server

Hi,

I have an excel file with 20 sheets inside. Currently, I have to click File Browse 20 times in Alteryx Server to direct to each Sheet separately one by one. Is there any dynamic way to help with this? What I want to do is to click File Browse once, the whole excel file will be uploaded to the sever and then based on the sheet name, data on each sheet will be transformed accordingly.

There are several ways to do it when running the Analytic App locally, but those ways cannot work with the Server, given the Folder Browse or Directory tools do not work properly with the Server.

Thanks,

Trung

Server

Apps

Dynamic Processing

Interface Tools

Accepted answers

gabrielvilella

The app will ask for the sheet name, but the workflow will just ignore that and replace the content from the user with the correct sheet name on each input tool. You need this expression on each action tool:

Regex_replace([#1],'(.+?)\|.+','$1')+Regex_replace([Destination],'.+?(\|.+)','$1')

File Browse.yxwz

All comments

gabrielvilella

One way to do this is having just one file browse and multiple action tools coming out of it. Then each action tool connected to an input tool. The action tool will update the path but not the sheet name.

trung2403

Hmm, I already tried but it did not work. When i run it on the Server, the server will require me to indicate a specific sheet as well. And thus, this method cannot work properly.

gabrielvilella

Regex_replace([#1],'(.+?)\|.+','$1')+Regex_replace([Destination],'.+?(\|.+)','$1')

File Browse.yxwz

trung2403

Hi @gabrielvilella

This is exactly what I'm looking for. Btw, may I ask another question? Let's say after this dynamic input, my WF on the server will generate 100 files. Currently, the user has to download all output files separately one by one. Is there any way to download them all in bulk?

Thanks and best regards.

gabrielvilella

Unfortunately it is not possible to bulk download files from the Gallery. You will have to create a zip with all the files and have the zip there to download, you might need to use the blob output to have the zip showing there on the results page.

deepaprash

As a continuation to the original question here, can the same thing be implemented in an regular yxmd workflow rather than an app? That is have one excel file sitting on sharepoint and bring it into the workflow with its multiple sheets and then feed the individual sheet data into the various arms of the workflow?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335