CSV Export Changes Column Order in Pyramid Discover/Presentation
Hi Team,
Greetings.
When exporting a CSV file from Discover or Presentation, the column order changes to a weird (non-alphabetical) sequence. I want the columns to export in the exact same order as created in Discover.
This works fine in Excel format, but only occurs with CSV. How can I preserve the original column order in the CSV export?
------------This is the Discover and see the order
------------After Exporting this in CSV format
Thank you in advance.
2 replies
-
If you export a tabular grid, the column order is correct. If you export a matrix grid, the dataset, driving the matrix is tabularized into a flat table - so it can be used properly as a CSV. Under that mechanism, there is no "column order" in a matrix grid, since the columns are drawing a cross-tab of your data - in spite of what it may look like. Excel is different, since a matrix grid is exported as the actual matrix to Excel.
-
Hi,
To retain the column order in the CSV, create a publication and include the discovery within that publication. Then export the CSV from the publication.
I hope this helps.