Input of files - schema does not match

Question

I am attempting to pull in data from multiple excel files based on the file name. The column headers match but I get a warning message to say that the schema does not match so skips all other files.

All I can think of is that some columns are blank in some files so maybe the data type does not match between files?

randreag · Answer

hi @greganderson

Yes you have to send the names of the files

I attached an example

let me know if you have more doubts

ExampleMacro.yxzp

greganderson · Answer

@aruiz-itp

Thanks a lot for the help.

I have tried the solution that you sent but suspect that I may be implementing it incorrectly as I have never really worked with Macros before.

I tried to set the input as the wildcard input that I was using or does it need to be a specific file name?

randreag · Answer

Hi @greganderson

this message is very common when you work with excel files. The best way to solve this is useing a macro to read the files, also in this way you can identify why you are getting the message.

I attached a macro that reads excel files, just put a directory , then add the name of the sheet  and then call the macro ,select the fullpath

I hope it helps

LeerArchivos.yxmc