Replace blank column value with specific value using linq

we would suggest to do it with a for each row activity loop.

For learning purpose a LINQ could look like this

For Each row As Datarow In dt.AsEnumerable().Where(Function (r) IsNothing(r("Column1")) OrElse String.IsNullOrEmpty(r("Column1").toString.Trim))
  row("Column1") = "Undefined"

used within Invoke Code

Here we only do use LINQ for the filtering and do mirroring the for each activity on code.

Updating is stressing the LINQ concept and results quickly to avoidable black box approaches

Find starter help here:
InvokeCode_1Col_IfEmpty_SetDefault.xaml (6.9 KB)

1 Like