Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

Target column structure for table transforms (like field transform)

It would be great to filter and rename the set of output columns directly within table joins, table views and extracts ...similar to field transforms. (see screenshot) This would save time as well as a couple of additional elements in the ETL flow chart. Today after table joins I often add an additional field transform because I only need maybe 3 out of 10 columns from the join...and maybe 2 of them with another name. Thanks JC
  • ADMIN RESPONSE
    Feb 26, 2021

    Thanks for the idea. This feature already exists in Jedox since 2020.2. You can find more information about it in the Jedox Knowledgebase.

  • Guest
    Reply
    |
    Jul 2, 2019
    The current option to define output columns in cube extracts is a good start. But loking deeper it is very limited, as you cannot remove dimensions, which are used in the dimension filter. So the definition of output columns is applied before the dimension filter is executed. This is the wrong order! You need many dimensions just for filtering - but not as ouput in the cube. So please Jedox team switch the execution order: 1st. apply dimension filter 2nd. apply output column definition thanks a lot!