Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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.

 

binuacs
21 - Polaris

@Akeelah sample workflow attached

image.png

apathetichell
20 - Arcturus

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

Labels
Top Solution Authors