Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
It would be great to just define such formulas directly in the variables section of the ETL project.
Right now you would need a separate groovy job for this which is too much overhead for this simple task
and creates unnecessary complexity within the flowchart / ETL process.
This is possible now using Groovy-sourced variables. The API.getproperty() function can be used to fetch another variable’s value, which can the be manipulated in the groovy script.