Custom expression when performing unpivot/pivot data transformation
It would be useful to have the possibility to use custom expressions in pivot transformations. This would allow users to already create tailormade columns during the transformation phase, rather than once the data is loaded completely.
7
MERGED
Add selecting columns by-expression option to the pivot select-column window
Merged
Pls, refer to the attached .pptx.
Our users require to have the same functionality with the TIBCO pivot transformation.
The user needs to reselect parameters of the pivot(via refresh table with prompt) when running a template for different produc...
Have checkbox in Unpivot Transformation UI to automatically "transform" new columns from source. This is useful for common 'wide' data sets where new time-series data comes as new columns in source. Whenever the source updates, currently one must ...