Input file Multiple Tabs- to run multiple processes

Question

Hi,

I have an input Excel file with about 30 tabs. Out of these 30 tabs, I only require 3 tabs and for each tab run 5 different workflow processes.The spreadsheet always has the same tab names and in these tabs which are required the format of data is always the same.

When designing this as .ymd this is fine, as I have designed each workflow process separately.

However I wish to design this as an app. Is there any way I can get the main file to import and then filter on the 3 tabs which are required and then connect them to run individual processes?

This may be harder to understand, so please do let me know if any further information is required.

Regards

Biren

MichalM · Accepted Answer

@Biren24

You could achieve this by configuring your Input Data module to read in the List of Sheet names

This step would be then followed by 3 filter tools which will allow you to select the relevant sheets for each stream - Tabs 1, 2 & 3.

You will then feed these into a Dynamic Input module and dynamically select the sheets you're interested in. Here's more on how to use the Dynamic Input module

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480