How to insert an Excel file with multiple sheets as an input via Alteryx Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Apps
- Dynamic Processing
- Interface Tools
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks for your advice, it works as expected now. :D
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?