How to open multiple sheets (same scheme & name) in different excel file at same directory

[acaryasin01]

Hi,

I have two excel file and  each of two have two sheets and sheets have same scheme and same name.

How can I open at once?

When I tried to open with wildcard ........\.........\............\*.xlxs  like this I got below error.

Then When I tried to reach sheets list on configuration window "Table or Query"

I got different error "Unable to file for read: .........\.........\........\........\*.xlxs"

Best regards...

[atcodedog05]

Hi @acaryasin01 

Were you able to normally open the excel file using filename in Alteryx using input tool?

[acaryasin01]

Thanks for quick respond :)) @atcodedog05 

Yes I did.

I can open seperately each file by using input data tool but When I tried to open together, It doesn't work.

[atcodedog05]

Hi @acaryasin01 

Its working for me when i try out with an example.

You can try 3rd method from this blog https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t... 

Hope this helps : )

[acaryasin01]

Thanks @atcodedog05 

Still trying to figure out what is the problem, I think it's about my files and its scheme!

But your message was so useful