How to organize the questions and input while running the Analytics App ?

[madhurinani]

Hello,

I have 5 different inputs, but all coming from the same excel workbook.

and all the outputs would also go in the same excel workbook but different tabs.

When I used the File Browse and Action method to input my files. I see so many drop downs.

Below is my question

1: Can i somehow put a reference to just the workbook and then based on the tab name,alteryx would automatically load the data on that tab for the respective input data?

I would like to reduce the manual effort of selecting the same workbook 5 times for my client.

Thanks,

[Robin_McIntosh]

Can you give us a screenshot of your workflow or if possible attach the workflow?

[madhurinani]

@Robin_McIntosh : I wont be able to attach the workflow as it has client data.
But here is the screenshot of it. 
It is messy as I am learning Alteryx and its not formatted as per standards.

Red - I/p

Purple - O/p

[OllieClarke]

Hey @madhurinani 

you can connect the same file browse tool to multiple input data tools, then if you update the value of the file, but replace just the filename, each tool will input the same sheet, so you only need 1 file browse tool:

Hope that helps,

Ollie

[OllieClarke]

@madhurinani you could set up the output data tool in a similar way, so you'd only need 1 file browse per file

[madhurinani]

@OllieClarke in the example that you mentioned, 

I see superstore is the input used. But Does superstore has multiple tabs/sheets in that workbook which would be sued by different input files?

Also, can you upload the excel file and workflow separately as I use an older version and i cant open the package.

[OllieClarke]

@madhurinani yup, 3 sheets in superstore, all are being input off the 1 filebrowse

I've uploaded the app along with 2 different versions of superstore here

[madhurinani]

@OllieClarke : I tried re creating the steps.

I get the below error.

Below are some of the i/p screenshots.

I get the option to select the file name

Input Data 1 configuration:

What could be the cause of the above mentioned error then?

[OllieClarke · Accepted solution]

@madhurinani in the box at the bottom, you'll want to delete the 3 pipes ('|||') and everything to the right of them. We want to change the file, but not the sheet name.

[madhurinani]

@OllieClarke : Thanks.

your suggestion worked like a charm.