Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
19 - Altair

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

Labels