Reading in specific sheets in Alteryx using dynamics input tool

Question

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"?

Screenshot 2024-01-24 230319.png

apathetichell · Answer

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

binu_acs · Answer

@Akeelah sample workflow attached

RemoveSheet_240124.yxzp

Raj · Answer

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