CSV sort

[aizuddin2070]

hi,

I have a question on CSV export. When I export my CSV files, the date is not sorted descending based on my table view. May I know why CSV is not sorted based on my UX.  Attached is the picture issues

[Joseph_Seddik]

1. You have data residing in a sheet table. Rows are added one after another in the order in which they arrive. 
2. This data can be sorted when viewed  in a UX View, using the ordering settings you define in this view. Additionally, users can click on the headers in a table view, to sort these rows by any column in their current View. 
3. The data in the sheet is not sorted. The UX View sort affects only the view. 
4. The CSV file is an extract from your sheet. It will contain the rows in the order they are in the sheet. 
5. You can open the CSV file with a Spreadsheet program (like Excel) and sort them manually using the program.. or through scripting. 

[Joaquin_Otero1]

Hi @Joseph_Seddik 

In my case point "d" is not happening.

This is the google sheet:

This is the table data (the same order than the google sheet):

And this is the csv file opened in Excel:


You can check the column Lote to notice that the order is not the same.

In some way Appsheet is sorting the CSV data before export. I'm using a slice of the table, maybe that's the answer, slices may be sorting data before export.

[Joaquin_Otero1]

The answer wasn't Slices, It was Group by ordering.

First it responds to Group by order and then to Sort by order.