Cleaning up and converting multiple numerical fields

Question

I have a source data with ~130 fields. About half of them are numeric and filled with text and special characters. What are the disadvantages of converting the [dirty] fields first then using dynamic select to remove all non-numerical characters (like the attached)? I went that route as I didn't want to select every field in the data cleansing tool.

Untitled.png

ScottB1 · Answer

@flying008

It's basically just columns that are 95% numeric (or null) but some rows contain "NA" or "Not Found". The approach I took works fine it just generates a lot of field conversion warnings.

flying008 · Answer

Hi, @ScottB1

Maybe you can upload some example data for input and output.  so what your want? like dynamic select fields?