Hi!
I’m having trouble configuring the Pivoting node to work with variables. Specifically, the column I want to group by will be selected via a user component. Perhaps this question is as simple as what setting to select.
I believe I’ve tried every setting and have received errors. The error is:
WARN Pivoting 3:138 No grouping column included. Aggregate complete table.
It’s not really clear where I should put my variable (string). When I place it in ExclList, I get the error “No grouping column included. Aggregate complete table.”
This is tricky because of the way most nodes handle these array-type settings. Firstly, you need in the ‘normal’ tabs to add the number of columns you want to control:
Thanks Steve. I admit I did not even try that because it doesn’t make logical sense to place a column in the Group tab when you know Group will be controlled by a variable. But – Just tested it with my Column Selection Configuration and it appears to work. Thank you!
No problem. It’s definitely a bit counter-intuitive, but basically you have to create one or more placeholders in array-types. I think the December release might be going to include more variable types and array variables, so hopefully that will make these simpler, although I would imagine there will be a period of transition