Table column operation mass
Apply operations stored in table to another table
Task to apply a list of operation contained in a table to another table. This is useful to apply a lot of operations.
Calculation column config defines operations to apply to the input table.
The input table must not contained special caracters in the column names
Let's say you have this
Table with the column A, B, C, D
Here is few example that you can write in the
- Addition :
A + B + C
- Constant :
A + 10
- Subtraction :
A - C
- Multiplication :
A * C
- Division :
A / C
- Exponentiation :
A ** C
- Modulus :
A % C
- Floor division :
A // C
- Advanced exemple :
(A + B) / (C * D)
This task support comparaison, it will return the string
Comparaison operators :
This task supports basic math functions :
Only works if
Error on unknown column is checked
Error on unknown column
Error on unknown column is unchecked, the operation will not fail on unknow columns (the result for operations with unknown column will be 'NaN') but only basic operations and comparaison are supported (no functions).
Error on unknown column is checked, the operation will fail on unknow columns (raise an exception) but it supports all operations.
Name of the column in Operation Table that contains operations' names. If not provided, the first column will be used
Name of the column in Operation Table that contains operations' calculations. If not provided, the second column will be used
If true, the original columns of the Table will be added at the end of the Table. If false, only the calculcation columns are kept.
If true, an error will be raised if a column is not found. If false, the result will be 'NaN'.