I had 29 columns that needed to have the following transformation:
iferror(parsefloat([Col1]),0)
The incoming file had all the data in scientific notation with “NA” for nulls which I needed to replace
I ended up just highlighting all 29, using the trim operation, and then editing the XML with some find/replace. Is there a better way to apply a transformation like this to many columns?