We have a file that has mostly numeric data in one of the columns, but is blank in a couple of the rows. For a variety of reasons, we would like to replace that blank with a 0.
How do I accomplish this in the data feed?
1 Reply
-
Hi Bob,
You can use the 'Replace values' operator in the data and set the criteria to 'Is Empty'. Then specify the new value as '0'. Note: the column that you want to update must be the same as the column that you have selected for your selection criteria.
Regards,
Jonathan