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 r093

D toc

Excerpt

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
rtrue
, 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
Typestep
p01NameColumns
p01ValuecolA, colB, colC
p02NameFormula
p02ValueIFVALID($col, ['Float'], ROUND($col, 2))
SearchTermEdit column with formula

See Column Details Panel

For more information, see ROUND Function.

Standardize units

Tip

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
inCQLtrue
label(label = "cleanse_tasks")