Input multiple sheets from multiple '.xls' excel files

Hello all

I have submitted my query to the history of posts before posting myself and found many very cool looking solutions, but did not solve my issue.

My situation :

I have 27 identically configured excel files with each having three same configured sheets I want to input "in one go". I also want to be able to trace sheet name.

They are "unfortunately" .xls formats. The file names are like 'PE - 1.xls'. When I try to apply 'dynamic input' I get awkward string error messages (unable to see sheets - see below). When I wish to select multiple sheets in the 'input data' I cannot select multiple sheets, only one at a time.

Is there anything I am basically doing wrong ?

Is it linked to the "-" symbol in file name ?

Thank you for your tips.

Chris

Input

Accepted answers

afv2688

Hello @dataminerchris ,

I have seen now the problem. You have to do a litte modification on the workflow. On the macro 'multidynamic_union_1 you have to change and erase the action tool on the 'list of sheet names' and change it for an text input with the name of your sheets: M1, M2, M3.

That is all,

Cheers

afv2688

Hello @dataminerchris ,

You have to set the workflow in the following order: yxmd-> dynamic_union_1 -> dynamic_union_2. So it is a workflow with a macro and a macro within a macro.

I did creat 4 xls files to try it out and it works perfectly, you just have to select the folder. Try to run it first as a workflow before trying it as an application.

It should work.

you can see in the example, if all sheets (named them here client) are named the same it works without problems.

Cheers

multidynamic_union_2.yxmc

multidynamic_union_1.yxmc

multidynamic_union.yxmd

All comments

afv2688

Hello @dataminerchris ,

This is a workflow I did a while ago. It selects all the sheets from the specified xls. Tell me if you need some assistance

Cheers

multidynamic_union.yxmd

multidynamic_union_1.yxmc

multidynamic_union_2.yxmc

dataminerchris

Hello afv2688

thanks for the prompt reponse. I will try these asap.

Being really new to Alteryx, I have not yet tried dynamic macros...so this is a good first test for me.

regards

Chris

dataminerchris

Hello again,

How should I use the three files you attached ?

I downloaded all three and opened them in Designer. I tried adapting various configurators to my situation (directories, file names). I tried to parameter the union1 macro to my situation : I get the error notification "the Microsoft Access engine cannot find the object 'list of sheet names' " and the routine goes no further.

So I am still stuck indeed.

Thanks for any further hint.

rgds

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703