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 next

...

D code

derive type:single value: myCol as:'myNewCol'

Column names with spaces or special characters in a transformation must be wrapped by curly braces. 

Example: Below, srcColumn is renamed to src Column, which requires no braces because the new name is captured as a string literal:

D code

rename type: manual mapping: [srcColumn, 'src Column']

After the column has been renamed with a space, it must be referenced in curly braces to be renamed back to its original name:

D code

rename type: manual mapping: [{src Column},'srcColumn']

Functions

Some parameters accept functions as inputs. Where values or formulas are calculated, you can reference one of the dozens of functions available in

D s lang
.

...