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.
Jens Lorentz commented
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!