Lookup a file which contains the column list in order to check the value of columns in a dataset

Have you looked at the AttributeValidator?

Yes, I have. Do you mean that I have missed something in AttributeValidator which actually can be used in my situation? If yes, would you please advise me how to make it work?

If you just want to check the values of Boolean columns, the attribute validator will allow you to select multiple columns to validate with the same statement, no need to create multiple cumbersome test statements.

If you want to actually define columns to check in a separate file for some other reason then it may not be the correct solution

Thank you for your response. My objective is to define the columns I want to check in a separate file, and then use a transformer to read that file and utilize those columns for checking.

In my data file, there are over 150 columns, with approximately 120 of them being boolean columns. From these boolean columns, I would like to check around 100 specific ones. Additionally, the number of columns in the file may grow as more projects are created. Although I understand that the file's structure may not be optimal, it is provided by other parties, and I have no control over its design.

Given this situation, the most straightforward approach for me is to create another file that stores the names of the boolean columns I want to check. I can then use this configuration file to efficiently check all the columns I need. Extracting the desired columns from the CSV file is not challenging since the ones I want to check are located at the end of the file.

By implementing this method, I can easily manage the columns I want to analyse, and it allows for flexibility as new projects are introduced. Thank you for your understanding and support in this matter.