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.
ADMIN RESPONSE
Jul 4, 2019
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.
