I very often work with pivot and I love it. However, when it comes to naming of the resulting table for e.g. heatmaps, I need an extra rename node to get the column names the way I want them. The closest option "Keep original name(s)" returns the pivot name, a plus sign, and the manual aggregation column name (i.e. "variableName+value"). However, I wish there would be an option to name the columns as pivot column name when there is only one manual aggregation variable. (i.e. "variableName"), see attached picture. I wonder if anybody else has a similar problem. Using the second node is not very intuitive but cumbersome.
Currently I help myself with an additional Column Rename (Regex) Node with Search string: (^.+?)(\+.+$) and Replacement: $1
Best regards, Max