Make sure the null value is replaced with 0

[491114473 (William)]

How to determine if the value is null, and replace it with 0?

[NIVED_NAMBIAR (NIVED N)]

U can use if condition with condition as row(ColumnName).ToString.Equals(" ")

If the condition is true then assign that row with 0 value

row(ColumnName)=0

[491114473 (William)]

@NIVED_NAMBIAR Thank you!
I want to convert con2 and con4 to double comparison, But the CON4 column has empty values.
Unable to convert error!
Thank!

[NIVED_NAMBIAR (NIVED N)]

U can use the if condition before converting to double for comaparison so as to handle the error

Like

row(ColumnName).ToString.Equals(" ")

[491114473 (William)]

Can we do it in the if condition?I have multiple columns, it’s going to be slow before if.
Thank~

[NIVED_NAMBIAR (NIVED N)]

Hi @491114473 did u mean u need to use it without if condition?

[491114473 (William)]

The if expression replaces the null value with 0.

Thank you!