Compare a column list to a data table

I have a list of columns in the config file, I wanted to read an excel file and check for each column of the list extracted from the existing config well in the generated excel file.

Thanks for u’re help.


This will give the column names as array from the datatable and then you can now compare the values from your config if they are present in the array

(from P in dt.Columns.Cast(of DataColumn)Select P.ColumnName).ToArray


Hi @Sarra

Please check the below workflow:
Column Check.xaml (13.5 KB)

This would help you in finding if all the columns mentioned in Config are present or not.


Happy Automation! :smiley: