Reading in specific sheets in Alteryx using dynamics input tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Akeelah
7 - Meteor
01-24-2024
02:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
Please,
Is there a way to read in, for example, I have an Excel which has 3 sheets "Flow, Non-flow & Seat number" and I want to read in 2 sheets "Flow & Non-flow" without "seat number"?
3 REPLIES 3
Raj
16 - Nebula
01-24-2024
02:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Akeelah yes, this is possible
first use the input tool to pull sheet names only then apply a filter to remove the unwanted and then use Directory tool to read the required.
binu_acs
21 - Polaris
01-24-2024
02:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Akeelah sample workflow attached
apathetichell
20 - Arcturus
01-24-2024
04:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
just use a batch macro. as @binu_acs shows - use a batch macro for this. don't use dynamic input.

