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
Météore

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 RÉPONSES 3
Raj
Magnétar

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

@Akeelah sample workflow attached

image.png

apathetichell
Pollux

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

Étiquettes