Forum Discussion

mttwss's avatar
mttwss
Frequent Visitor
3 years ago
Solved

query to return files in folder with errors

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. 
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    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.

ImkeF's avatar
ImkeF
Community Champion
3 years ago

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.