Compare a column list to a data table

Hello,
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.

@Sarra

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

cheers

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.

Thanks

Happy Automation! :smiley: