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 products.
Is it possible to make "by the expression" available in pivot? Then, the user does not need to reselect the parameters of the pivot.
Thanks!