Replace Blank\Null values on datatable

[ton (Anthony)]

Try this reference:

REplacing Values in a column of datatable

e.g. invoke code and: yourDataTable.AsEnumerable.ToList.ForEach(Sub(row) row(“ColNameOrIndex”)= row(“ColNameOrIndex”).ToString.Replace(“your old value”,” your new value”))

I applied it too on the example you provided:
Put Value on Blank or Empty.xaml (18.4 KB)

But I wouldn’t necessarily advise a solution that uses For Each or Loop especially when you are processing hundreds of thousand of transaction rows and as you mentioned 65 columns in a Data Table. It might cause a longer processing time and worse case a ‘job stopped’ as we experienced from our previous projects. But if you are only dealing with less than a 100,000 transaction rows, I think this approach is still safe.