Input of files - schema does not match

[greganderson]

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]

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

[greganderson]

@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]

hi @greganderson 

Yes you have to send the names of the files

I attached an example

let me know if you have more doubts