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

Using Directory tool to upload certain sheet on multiple files

fikrizahari
8 - Asteroid

Hi,

Greetings !

I have multiple files ( up to 20 xls format file ) and I use Directory tool to upload all files, then filter require file :

fikrizahari_0-1687231777081.png

 

fikrizahari_1-1687231794889.png

 


The result show as below (which is correct) :

fikrizahari_2-1687231985688.png

 


However, i have difficulties to use dynamic input tool, since all above file contain multiple tabs on each files.
I would like to input data from 'Sheet1' tab from each related files.

Kindly find dummy files as per attached.
Thank you in advance !

8 REPLIES 8
fikrizahari
8 - Asteroid

Hi @Qiu ,

Thank you for you sugesstion.
It is definitely a great macro tool to read xls and specific sheet.

However, since i already have existing directory tool which link to another workflow,

do you know how to combine filter tool ( yellow highlighted ) with the Macro tool ?

fikrizahari_0-1687253449373.png

 

binuacs
21 - Polaris

@fikrizahari You don't need to use a separate directory tool for this macro, all options available in this macro, check the Folder and Options tab in the macro

 

binuacs_0-1687254517695.png

 

Qiu
21 - Polaris
21 - Polaris

@fikrizahari 
I am sorry if I misunderstand your question.
but do you mean something like this?

Or you want to stick to your directory tool?

0620-fikrizahari-A.PNG

Qiu
21 - Polaris
21 - Polaris

Right.
 I just realized that we can not really import the Sheet List for XLS files.

So using above Macro might the only choise we have.

0620-fikrizahari-C.PNG

fikrizahari
8 - Asteroid

Hi @binuacs,

As per my first posting, there's much more different files that require different preparation and massaging.
So, I already have existing workflow which start with Directory tool, however i find difficulties on filtering 'specific' tabs for xls file type.

Currently i was able to figure out how to connect with the 'Excel File Opener' macro tool with some changes on that macro.
Below is my current workflow :

fikrizahari_1-1687333754562.png



Hi @Qiu,

I would like to combine the existing filter tool with the new 'Excel File Opener' macro tool.
As per mentioned above, below is the changes I have done on the macro to suit my requirement :

The existing tool on the 'Excel File Opener' macro tool :

fikrizahari_2-1687334099305.png

My version of the 'Excel File Opener' macro tool :

 

fikrizahari_3-1687334224633.png

 

Hence I was able to link the macro tool with my existing Filter tool
Hope its clarify !

Thank you once again !

 

Qiu
21 - Polaris
21 - Polaris

@fikrizahari 
good to know it works for you. 
Thanks for the feedback!

Laksh345
6 - Meteoroid

It is not working. i am trying to import multiple excel file from the same folder with same header. 

Labels