How do I split a single Excel file into multiple outputs w/sheets w/different schema?

[SergeantJack]

Hello, thanks for taking the time to read my question.  I'm designing a workflow that will become an interface.  The user will be prompted to choose between selecting a file (single input) or a folder (batch input), and that choice will take an Excel file (or files), run it through my workflow, and output as a .CSV file.

My problem is this: the incoming Excel files, and the template upon which they're based, have two worksheets with completely different schema.  I want this to happen:

1. User selects Excel file using the interface

2. Alteryx sends input from Worksheet A into workflow A, and Worksheet B into workflow B, without prompting the user to specify the worksheet (since all incoming Excel files will have these two worksheets with these exact schemas)

3. Workflows A and B go through their separate parsing and data cleansing processes

4. Both workflows are joined together into one row of data

5. That row is exported into a .CSV file

I can get everything to work except #2, above.  I can't seem to figure out how to tell Alteryx to automatically divvy up the worksheets to their respective workflows.  Please help!

[danilang]

Hi @SergeantJack 

When an Interface tool opens an Excel file, the user is ALWAYS presented with the option to select a sheet. There is no way to turn this "feature" off.   Instruct your users to click the Import only the list of sheet names option. 

This will return the 2 sheets in your file. Split the two using a filter and send each path to separate Dynamic Input tool to load the data from each sheet as a separate data set.

Dan