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 Dec 8, 2021

Multiple Table Joins in one transform

As a Model Builder, I want to join multiple sources in one single step so that I can accomplish my tasks with as little ETL footprint as possible and have a more intuitive ETL Flow Graph.

Often there are multiple sources where values have to be retrieved from. Currently you either have to do multiple joins one after another to gather all the values or you have to define several lookup functions in a field transform. The latter seems to be less performant than table joins (when multiple values/columns of each source are needed).

A new type of transform should be introduced where multiple joins can be done. One source could be joined with multiple other sources. For each of the other sources the join type and columns should be defined.