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.
解決済! 解決策の投稿を見る。
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