The function accepts only two ON clauses. One for the InputTable and one for the TransformationsTable. Both InputTable and TransformationsTable are required.
InputTable Schema
| Column | Data Type | Description |
|---|---|---|
| input_column | VARCHAR (CHARACTER SET LATIN or UNICODE) or NUMERIC | Column whose name can appear as TargetColumn in TransformationTable. |
TransformationTable Schema
| Column | Data Type | Description |
|---|---|---|
| TargetColumn | VARCHAR (CHARACTER SET LATIN or UNICODE) |
Name of InputTable column to transform. |
| Transformation | VARCHAR (CHARACTER SET LATIN or UNICODE) |
Transformation to apply to TargetColumn—for allowed transformations, see following table. |
| Parameters | VARCHAR (CHARACTER SET LATIN or UNICODE) |
[Optional] Transformation parameters in JSON format. If this column is absent and transformation has parameter, function uses default value in Parameters column of the following table. |
| DefaultValue | NUMERIC | [Optional] Default value for transformed value if TargetColumn is nonnumeric or NULL. If this column is absent, function uses default value 0. |
Allowed Transformations
If a transformation requires parameters, they are specified in JSON format as mentioned for log and power in the following table.
| Transformation | Parameter | Operation on TargetColumn Value x |
|---|---|---|
| ABS | None | |x| |
| CEIL | None | CEIL (x) (Least integer ≥ x) |
| EXP | None | ex (e = 2.718) |
| FLOOR | None | FLOOR (x) (Greatest integer ≤ x) |
| LOG | [Optional] {"base": base} Default: e |
LOGbase(x) |
| POW | [Optional] {"exponent": exponent} Default: 1 |
xexponent |
| SIGMOID | None |  |
| TANH | None |  |