Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future Consideration
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Nov 22, 2024

Global Field transforms

In integrator, it would be very useful if we could generate a global field transform (within a project, or within a certain workspace). For example, during data inputs, customer ID should be processed by a groovy, concatenation, or any other field transform. (eg. removing certain characters) This transform requires N input for it to work. Because there are many occasions where one should use this field transform, instead of re-writing this field transform many times, we just inwoke a global field transform, and as long as we provide it with the proper number of inputs, it always returns the desired values. Basically it will be a function which can be used anywhere in integrator. --> It can be maintained in a single place, resulting in a much easier development.

  • ADMIN RESPONSE
    Nov 29, 2024

    Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully. 

  • Guest
    Reply
    |
    Nov 29, 2024

    So its basically a function in a field transform, that is accessible globally. So within a field transform apart from the existing funtions, like groovy, concat, dateformat, etc, you can choos a global function. And after editing the global function within a specific transform, you can select the global transform from a drop down and the inputs (parameters for it) In itegrator, it requires a new category within a project, where you have connections, extract, transforms, loads, etc, there is a new category called global transform.