Common logarithm
The Common logarithm step computes the common logarithm of the input values (log10(x) or sometimes also log(x)). Common is a logarithm with base equal to 10.
Parameters
-
Input column: a numeric column (decimal or integer).
-
Target column: configure the column which will receive the output. Output will always be of decimal type.
-
Write result to the current column: overwrite the input column with the result.
-
Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed right after the input column.
-
Examples
Input value | Output value | Description |
---|---|---|
1 |
0 |
|
1000000 |
6 |
|
-2 |
Error |
Common logarithm is not defined for negative numbers and results in an error. |
0 |
Error |
Common logarithm is not defined for 0 and results in an error. |
No value |
Error |
No value input results in an error. |
Remarks
-
Applying the step to No value cells (cells containing null) will result in an error.
-
Common logarithm step can only be applied to values greater than 0. Common logarithm is not defined for zero or negative values and will return an error.
See also
-
log10
function in CTL.