Exclude files based on missing column

Question

Hello,

I am trying to read multiple csv files form a folder, in those there is a column called “Time”, but few of the files have this column missing, need help to skip those files and further operation to be done on the files which have “Time” column in them.

Marco_Barradas · Accepted Answer

Hi @Kumar_Ayush:

You could use the Branch operator with the check for attribute_available, and if it's not skip the file.
If the attribute is available and all of the examples are missing for it you can also build some logic arround it.

Data Engineering Master - Handle Exceptions and Branches | RapidMiner