...
figure 1: Apply Transformation window
By selecting the 'Only apply to missing data' checkbox, the transformation will only be performed for the selected fields that do not already contain a value.
A regular expression can be composed using the following elements:
...
function | description | example |
---|---|---|
sum | sum of values | sum(A,B,...) |
abs | absolute value | abs(A) |
pow | power function | pow(A,2) |
sqrt | square root | sqrt(B) |
min | minimum of list | min(A,B,C) |
max | maximum of list | max(A,B,C) |
average | average of list | average(A,B,C) |
exp | exponential (e^x) | exp(A) |
ln | natural logarithm | ln(A) |
log | logarithm base 10 | log(A) |
atanh | inverse hyperbolic tangent | atanh(A) |
acosh | inverse hyperbolic cosine | acosh(A) |
asinh | inverse hyperbolic sine | asinh(A) |
tanh | hyperbolic tangent | tanh(A) |
cosh | hyperbolic cosine | cosh(A) |
sinh | hyperbolic sine | sinh(A) |
atan | arc tangent | atan(A) |
acos | arc cosine | acos(A) |
asin | arc sine | asine(A) |
tan | tangent | tan(A) |
cos | cosine | cos(A) |
sin | sine | sin(A) |