Reformatting

These transforms modify a field in place. They do not produce an output and the original input is replaced.

• Cast: Change the data type of a field
  • Usage
  • Example
• Fill: Fill in missing values by copying down
  • Usage
  • Example
• Format: Replace a value with a computed value
  • Usage
• Lookup: Replace a value with one from a lookup table
  • Usage
• Lag: Shift values by a number of rows
  • Usage
• Lift: Fill in missing values by copying up
  • Usage
• Replace: Rewrite a string using capture groups
  • Usage