Page tree

Versions Compared


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

D toc


This section describes techniques to normalize numeric values in your datasets.



Ideally, your source systems are configured to capture and deliver data using a consistent set of units in a standardized structure and format. In practice, data from multiple systems can illuminate differences in the level of precision used in numeric data or differences in text entries that reference the same thing. Within

D s product
, you can use the following techniques to address some of the issues you might encounter in the standardization of units and values for numeric types.


D trans
p01ValuecolA, colB, colC
p02ValueIFVALID($col, ['Float'], ROUND($col, 2))
SearchTermEdit column with formula

See Column Details Panel

For more information, see ROUND Function.

Standardize units


Tip: Each column that contains numeric values should have an identified unit of measurement. Ideally, this information is embedded in the name of the column data. If the unit of measurement is not included, it can be difficult to properly interpret the data.


For more information, see Pivot Data.

D s also
label(label = "cleanse_tasks")