Jedox Ideas

Let us know how we can make Jedox even better!

Add a new idea Subscribe
Status Shipped
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

RELATED IDEAS

Set a Variable by using a FieldTransform Function

For those People, who are not so familiar in coding groovy it will become a challenge setting a Variable in the ETL-Manager by scripting groovy. So it would quite helpful to have a separate FieldTransform Function, which enables the user to set a variable directly. It would be also quite helpful, if the possible conflicts with datatypes could be solved with such a function..! example: There is an extract with 1 column and 1 row: number of reords 4562156 Calculate anything with this number... number of reords | records/50000 | counter | set_variable | get_variable | 4562156 | 91,24312 | 91 | | 91 | In the column 'set_variable' the variable is set as the groovy function API.setProperty("variable",counter) would do, if there weren't so much possibilities to get conflicts with the DataTypes In the column 'set_variable' the current variable is shown... ...end of example
  • ADMIN RESPONSE
    Jul 2, 2019
    A FieldTransform is not the right place to define variable values To achieve this you can: Alternative 1: - Create variable "number of records" - Create new transform of type TableLoop with * Loop source: The extract with 1 column (named "number of records") and 1 row * Data source: The source which uses this variable anywhere Alternative 2: - Create variable "number of records" - Create new job of type eLoop with * Loop source: The extract with 1 column (named "number of records") and 1 row * Execution type/name: A load or job which uses this variable anywhere Handling of datatypes is a separate topic.