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”
@cvo,
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)
