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
14 - Magnetar

@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
20 - Arcturus

@Akeelah sample workflow attached

image.png

apathetichell
18 - Pollux

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

Labels