Export to excel issue

Question

In database view has been created by combining many tables and it shows the results properly. When we use a!exportDataStoreEntityToExcel function to extract the content it fetches only 22k instead of 24k which is shown in view results. Is there any limitations on the extracting content except the column count 50 (ours only 25 columns)?

jordanDon · Answer

Hi harikumarm 
 My first question to you would be this from the documentation here : 
 " Exporting data store entities from either record lists or smart services relies on sorting the entity by its primary key. This sorting ensures that data is exported consistently&mdash;that is, all rows are exported and no row is exported more than once." 
 For the field configured as your primary key in you CDT, can you confirm that there are 24k unique values? If you only have 22k unique values then as the documentation suggests, not all rows may be successfully exported.