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.
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!