URGENT: How to input specified sheet for multiple excel files(xlsx) in alteryx

Hi,

Have created a Batch macro for reading multiple sheets for multiple excel files. However, i want to read only first sheet for all the 3 files.

sample data attached along with the batch workflow. Please guide how i can specify a particular sheet to be read.

Reading_multiple_excel_files_25.8.16.yxzp

Data1.xlsx

Data2.xlsx

Data3.xlsx

Input

Accepted answers

pcatterson

Sorry, there is a macro within a macro situation. You'll need this one as well.

Batch Sheet.yxmc

All comments

DultonM

Hi @vaibhav_jain! One option is to put a Sample tool right after your Input in the batch macro so that only the first record reaches the Dynamic Input tool (aka only the first sheet per batch is read). If you know the sheet's name in advance, you could add a filter in that same spot and add an interface tool to the filter that will allow you to enter the sheet name(s) you wish to keep. Hope this helps!

pcatterson

I've created a macro that I believe will be of help. It gives you the option to not only see the files within a folder, but also shows the sheets within an excel file as a new field called FullPathAndSheet. Then you can use a filter to specify which sheets you want to collect in the data and then run your batch macro.

Better Directory.yxmc

vaibhav_jain

Hi,

When i am opening the macro, getting a ?. The macro is not attached properly. Please suggest.

pcatterson

Sorry, there is a macro within a macro situation. You'll need this one as well.

Batch Sheet.yxmc

vaibhav_jain

Hi DultonM,

I have applied your logic of applying filter for selection of sheet1. The macro is working fine however when i am using directory tool to read the three files, its showing error. PFA workflow. Please guide.

Reading_multiple_excel_files_25.8.16_2.yxmc

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335