How to replace null value to 0 in a datatable without check cell by cell

Hi all,

As the subject suggests, if I have a datatable(dT) with 4000 rows x 25 columns and I need replace any null value to 0, but checking cell by cell is going to take more than 30 mins.

Is there any faster and more efficient way to do it?


Any luck? I am also looking for a similar workaround in the data table?

Find some starter help here:
Replace_AllCellsAllRows_EmptyNothingWith0.xaml (7.3 KB)

feel free to adopt it to your specific scenario


Hi @ianhyj :wave:

You can refer the below link for more:

This was solved by @ppr too!

1 Like