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

Question

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

image.png

acaryasin01 · Answer

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

atcodedog05 · Answer

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/ta-p/20480

Hope this helps : )

Output1.xlsx

Output2.xlsx

excel read.yxmd

acaryasin01 · Answer

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.