hi - is it possible to run a pivot step and then sequence the column headers.
I have a data set which is keyed by date_created, I pivot to get a count of records per date and type.
The output into excel however does not sequence columns based on date i.e. Jan-24, Feb-24, etc
Any ideas appreciated.
Thanks
Martin
Can you post an example input and the corresponding output you want?
Pivot output is tricky, specially when values don’t exist you had before, the order of the output columns change all the time. Typically I create a list of the headers which are possible or should be there and I combine it with STACK so that I have a list of with columns possible in the identical sequence every time.
See attached example:
Pivot Order.transform (5.1 KB)
From what I understand you need now to create. Header list with all the dates and you should everytime as stable output. If the header list I longer I recommend to maintain it in a file and read in instead of the clipboard.
You could perhaps use Sequence and Transpose to dynamically create all the possible dates to use for the Stack.
