Computes the value of the first argument raised to the value of the second argument. |
Numeric literal example:
derive type:single value: POW(10,3) |
Output: Generates a column containing the value of 10 3, which is 1000
.
Column reference example:
derive type:single value: POW(MyValue,2) as: 'sqred_MyValue' |
Output: Generates the new sqred_myValue
column containing the value of the MyValue
column raised to the power of 2 (squared).
derive type:single value: POW(base_numeric_value, exp_numeric_value) |
Argument | Required? | Data Type | Description |
---|---|---|---|
base_numeric_value | Y | string, decimal, or integer | Name of column or Decimal or Integer literal that is the base value to be raised to the power of the second argument |
exp_numeric_value | Y | string, decimal, or integer | Name of column or Decimal or Integer literal that is the power to which to raise the base value |
Name of the column or numeric literal whose values are used as the bases for the exponential computation.
Required? | Data Type | Example Value |
---|---|---|
Yes | String (column reference) or Integer or Decimal literal | 2.3 |
Name of the column or numeric literal whose values are used as the power to which the base-numeric value is raised.
Required? | Data Type | Example Value |
---|---|---|
Yes | String (column reference) or Integer or Decimal literal | 5 |