I'm trying to replace nulls in certain columns with 0 using the data cleansing tool. However, it is creating extra rows at the bottom of my data set with 0's. Is there a way to make this not happen. See picture.
Solved! Go to Solution.
Your incoming data likely has NULL row data (e.g. from Excel). Please try to FILTER the data where !IsEmpty([Field1]) might do the trick (field1 would be a field that ALWAYS has good data in it).
After that you can use the data cleansing tool or a MULTI-FIELD FORMULA to replace Null values with 0.
Cheers,
Mark