Input multiple files from same folder

Hi ,
I am trying to input multiple files from same folder using (*) having similar names with same format (input contents are having same rows)
I am able to pull out only two of them , not sure what is the problem ?

Could anyone please help?
Thanks in advance !

Input

Accepted answers

All comments

Emil_Kos

Hi @QurrathAmeena,

The rest of the files is in a different format.

Please input one of them manually and check if the names of the column/data types are exactly the same.

I think this will be quite easy to check and will allow you to understand where is the problem.

QurrathAmeena

Thanks for the reply @Emil_Kos .
I checked all the excel files have same structure but seems like it pulls out just two out of ten files , could there be any other problem?

mceleavey

Hi @QurrathAmeena ,

I've built a couple of tools to do exactly this.

I've attached them and an example workflow.

I hope this helps,

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Multi Sheet Import Example.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703