Filter data and update status


I wanted to filter data on behalf of column name “ckyc”, if ckyc column has data then it will write status “success”.
data.xlsx (10.4 KB)

Have a look here:

one approach is to filter and then update the filtered rows

for the filtering we can do:

dtData.AsEnumerable.Where(Function (x) Not (isNothing(x("ckyc")) OrElse String.IsNullOrEmpty(x("ckyc").toString.Trim))).ToList 

As an alternate also have a look on the approach with DataColumn.Expression

The Expression syntax allows us to exrpress it with an IF function and let calculate if it is success or not

Hello @Lakshya_Garg - Try with attached workflow (1.7 MB)