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!
