7.2.1 Data table exported column order differs from which displays on the screen

We have delegated a Data table to the end user, so end user can export / import data from the OOTB data table edit screen.

The exported CSV file contains  all record displays on the screen with different column order as attached image shows.

Can anyone explain why does this happen and how can I make sure the exported CSV has the same column order as the screen display ?


Many thanks!

***Updated by moderator: Lochan to update Categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

December 26, 2016 - 10:13am

Hi chunchi,

I did try to export the data type column information in 7.2.1 local instance. However I did observe that after exporting all the columns are in alphabatical order(ie. from A to Z).

If you can try running the Data Type export in data explorer and observe the behavior.

FYI, pzDownloadDataRecordsAsCSV  OOB activity is responsible for exporting the records.

P.S: I haven't tried delegating option.

December 27, 2016 - 12:50am
Response to Gangababu

You can reproduce the issue by creating a new Pega Express application. 

There will be a Data type called Product created by default and you can see that the column order is different between CSV and Screen display as belwo screen shot show.