Spotfire Ideas Portal
It would be useful to have a transformation that would apply the "TRIM" function to multiple columns at the same time. This is useful because when joining data tables, the text of the columns must match exactly. Therefore, TRIM is often applied to account of trailing spaces, and it is cumbersome to apply this "Calculate and Replace" transformation one at a time. If it could be applied to multiple columns in one move, efficiency would be increased, and fewer joins would mysteriously fail.