In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reading in specific sheets in Alteryx using dynamics input tool

Akeelah
7 - Meteor

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

@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

@Akeelah sample workflow attached

image.png

apathetichell
20 - Arcturus

just use a batch macro. as @binu_acs shows - use a batch macro for this. don't use dynamic input.

Labels
Top Solution Authors