After reading the data filter the datatable on remarks column empty â€¦then check the countâ€¦if count is zero all are processed else need to process those items

Hi @Gokul_Murali - Alternative way is you can do with Assign activity

Variable of type Int Count = DT.AsEnumerable.Where(Function(x) String.IsNullOrEmpty(x(0).ToString)).Count

DT is your data table name

x(0) represents column index, here Iâ€™ve assumed first column so given as 0, letâ€™s say if it is 5th column then it is x(4)

The above exp returns the empty values count in a column. If it is 0, means there were no empty values, >0 means empty values exists

So, you can take a IF, Count = 0

True
>> You can skip processing since there were no empty values in the Remarks col
False
>> Start processing, as the empty values exists in the Remarks col

In the initialization when youâ€™re reading the data from your input source,
right after reading the data please use a filter data table activity to keep the rows with Remark Column and condition as is Empty.

@Gokul_Murali - It looks like you have given wrong column index. x(0) means bot look at the first column and gives the result. May be that could be the reason everytime it gives the value as 4. But according to your input excel comments should be last column. So, youâ€™ve to change column index accordingly.

Ex: Assume in your input excel, comments column is 6th position, then in data table it has to be x(5) as the data table column starts with index 0. First colu index 0, 2nd col index 1â€¦