Input file Multiple Tabs- to run multiple processes
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
