"has a different schema and will be skipped" error skips import of multiple files

[Greenlama254]

 

Hi all,

I have seen several topics on this but I am not really sure what the problem may be and how to solve it.

On a daily basis a file comes in the same directory from where the flow picks them all up to add to a report. I use a regular Import data tool with a wildcard at the end.

All the files were picked up until 1 specific report was added (the one from feb 1st). The report has the exact same layout as all the others. 

However, the format of column N is different when empty (general) compared when in some of the cells in that other file are populated with numbers (custom) (see

pictures attached). Because of this (I suspect) multiple reports are left out of the data.

Could this be the reason why I get the error "has a different schema and will be skipped" and skips all the files that have this format difference?

Is there a way the flow can ignore the format of that specific column so that regardless it will import the data?

I do not even need the data in that column N.

Thanks for any help on this!

Roger

[binuacs · Accepted solution]

@Greenlama254 Since you are using the wild card method to extract the data from different excel fiels, it should be in the same schema, any changes in the datatype/column headings will skip the files, Use the batch macro to combine all your files instead of the wild card method, 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

[Greenlama254]

Okay thanks. With schema you mean "format", right?

I will give the batch macro a try then, although those things are not that easy for me.

thanks again

Roger

[Greenlama254]

I got a batch macro working. Thanks