is there a way to know which files don't contain any comulmns?

[Pippobaudo89]

hi all

as i described in the title, i d to know if there’s a way to have a list of which files don t contain some columns when i launch a excel/csv reader for multiple files

thanks in advance

cheers

[Daniel_Weikert]

In that case I would rather use a loop because loop end allows changing specifications e.g. different columns in the files.
br

[takbb]

Hi @Pippobaudo89 , as per @Daniel_Weikert 's suggestion, you could probably do a variation on the workflow here…

Excel reader

Hi @Ashok121 , that’s certainly a lot of Excel files to be processing! You could perform this by wrapping the Excel Reader with try-catch nodes and then handling any errors by then transferring files that wouldn’t open to a separate folder. Here’s a demo workflow [image] This may take a while to run with 500k files This workflow was written using KNIME 5.1, but should work equally with KNIME 4.7. The NoOp node is available from NodePit, and does nothing except provide a me…