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?
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
