David McClellan on 23 Apr 2017 11:48:16
Instead of having to know what values to filter and creating several replace value steps, an excellent data cleaning action would be to remove any non-numeric characters from a column you have set to be numeric. Vice versa could also apply. This would be a robust way to programmatically clean data when you don't know the dirtiness in the data that may come up in a future refresh