Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0810

...

You can use the following transformation which nests the TRIM and the TRIMQUOTES functions to clean up all of the columns in your dataset.

  • To apply across all columns in the dataset: 
    • The wildcard (*) for columns indicates that this formula should be applied across all columns in the dataset
    • You can also select All from the Columns drop-down in the Transform Builder.
    • Since all columns are String type, the results should be consistent.
  • The $col reference can be used to refer to the current column that is being evaluated. For more information, see Source Metadata References.

D trans
RawWrangletrue
Typestep
WrangleTextset col: * value: trimquotes(trim($col))
p01NameColumns
p01Value*All
p02NameFormula
p02Valuetrimquotes(trim($col))
SearchTermEdit column with formula

...