JSensei Member

Comments

  • Sorry my reply won't have a graphic. Fastest way to do it for multiple rows is to use "set column type" to convert all numeric columns to text, use the "replace text" to convert nulls to zeros, & then "set column type" again to convert back into numeric types. 3 steps no matter how many columns you're replacing values for.
    in Convert null numeric values to '0' in Magic ETL Comment by JSensei September 2018
Default Avatar