Hi I am creating a datatable from excel before further data processing and manipulation. Before beginning with additional steps, I’d like to check that all necessary columns (10+) exist in the datatable otherwise I will get errors in following activities. (data may change sometimes). I have seen the following condition used, but is it possible to check for multiple?
You can use it in If activity directly as the following image.
function(x) dt.Columns.Contains(x) is anonymous function.
x is sequentially set each array value.
Where method returns item if it contains x in your columns of dt.
As a result, if all columns which you expect exist, the result length equal strArrayColumn length.