Value Modification
This transformation modifies values in columns. The settings are:
Column: The name of the column that has the values you want to modify.
Operation:
- Plus (+): Add a value to the values in the column
- Subtraction (-): Subtract a value to the values in the column
- Division (/): Divide the values in the column by a number
- Multiplication (*): Multiply the values in the column by a number
- Modulo (%): Modify the values by a modulo.
- Exponentiation (**): Raise all the values to a power.
- Not (for boolean): Modify boolean values
- Prepend (for string): Put a value at the front of a string
- Append (for string): Put a value at the end of a string
Value (optional): The value you want to use to modify the entries.