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.
1 reply
-
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.