Labeling columns with separated top values

Continuing the discussion from Uncross cross-tab:

Could we have the possibility to specify a separator in the “label column” operation ?
If I want to split the “Labels” into several columns after the unpivot operation, space is not always the best separator.
On my current project I get : “draft 1 2018 quarter 1 southern Europe”
It would be easier with “draft 1|2018|quarter 1|southern Europe”


It just struck me how this can be done using existing actions – create a group from the first N rows and aggregate it with the “Concatenate” function and a separator. Then apply “Label columns” for the top row.

See the example attached.

label-columns-separator.morph (2.9 KB)


Maybe a dedicated transformation action would be a good idea ?