...
| 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 |
|---|
...
