how to input multiple different excel sheets for use in alteryx gallery

Im fairly new to alteryx so hopefully this is a simple one. I have a gallery app that links to many different worksheets in the same excel file. Is there a way to do this without connecting to each sheet individually ( as the dynamic input tool cannot be used)?

Common Use Cases

Accepted answers

JordanB

Hi @Kate

You can upload a macro within an application to the Alteryx Gallery, however I have taken a look at your workflow and I was thinking you could potentially go down this route (Workflow attached - built in Alteryx 10.6).

I have used the file browse as the interface, but used the formula tool to dynamically rename the file path and then used the dynamic input to read in all the sheets. The only requirement is the end user select "list of sheet names" when running the application.

You can still keep your filters in the workflow but you will need to do this after the formula tool.

Please let me know if this does not make sense.

Best,

Jordan Barker

Solutions Consultant

App - Read in multiple sheets.yxzp

All comments

JordanB

Hi @Kate

You will need to use a tool called the batch macro. I would suggest looking at this article as it describes reading in multiple sheets at one time into Alteryx.

Please let me know fi you have anymore questions.

Best,

Jordan Barker

Solutions Consultant

Kate

Hi Jordan

My understanding was that macros would not work when published in alteryx gallery? I need my app to be able to be run without having alteryx installed.

I can achieve what i need with a dynamic input tool (attached) but again am unable to publish to gallery with this setup. at the moment I have an input file for each sheet which is pretty clunky for the end user so if there is a way to do this it would be great

Cheers

Kate

test15th.yxmc

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703