query to return files in folder with errors

[mttwss]

I would like to have a query to return all of the files I am reading in a folder that have returned errors thereby reducing my time searching for the offending files which have errors. 

[ImkeF]

Hi @mttwss ,
if my answer solved your problem, please accept it as a solution as well. This will help others searching for a similar problem. Thanks.

[ImkeF · Accepted solution]

Hi @mttwss ,
I would use the combine binaries-method when importing from folder and create a query that returns only rows with errors. You have it all in one table then.

Of course, provided that all transformations should be the same on those files.
If that's not the case, you have to append all queries manually with an added column specifiying the query name. Then select rows with errors.