Arithmetic operation
You can perform arithmetic operations including additions, subtractions, multiplications and divisions in the Expression Builder.
As shown below, there is a new column called new_salary in the output table. Its value is the original salary plus 500.
The input data will be transformed to output data after being processed in the tMap component.
Input table:
| employee_id | name | salary |
| 1 | Elisa | 12000 |
| 2 | Nicolas | 13000 |
| 3 | Patrick | 10000 |
Output table:
| employee_id | name | salary | new_salary |
| 1 | Elisa | 12000 | 12500 |
| 2 | Nicolas | 13000 | 13500 |
| 3 | Patrick | 10000 | 10500 |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!