Good morning, I have already been able to solve the problem, if someone can help you, watching tutorials and reading about power query I found that having a reference excel and generating a GetData function for each of the necessary tables, I was able to bring from all the bases the tables and combine them into one, this is perhaps too punctual, I needed them agreed, but I share it in case someone ever serves it even if it is for reference
Getdata table Cli.dbf
the excel that is called in the query has an ID per database, the name of the database and the name of the directory folder that has the database
ex: 1 Castelar caste
Query calling Getdata
I hope I have not made it very confusing, thank you all very much,
Cheers.
Bookmarks