Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Input file Multiple Tabs- to run multiple processes

Biren24
6 - Meteoroid

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

1 REPLY 1
MichalM
Alteryx Alumni (Retired)

@Biren24 

 

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

 

MichalM_0-1600167354574.png

 

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.

 

MichalM_1-1600167760251.png

 

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/249...

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

 

MichalM_2-1600167780075.png

 

 

Labels
Top Solution Authors