Hi All, Is there a particular reason why a CSV file generated by the AppSheet has a random arrangement of the rows in the data table? When I refer back to the original Google Sheet, the rows are in correct order, but the CSV file shows data in a haphazard manner. Any reason for this behavior?
Good question I was just wondering that myself.
The action’s Do this actually says: App: export this view to a CSV file I just tested it and as expected if you set a sort order for a table view, the exported CSV file will respect the same sort order.
However if the view has no particular sort order, the generated CSV seems to be in random order. Perhaps in that case it should have been in key column order? @praveen
Or maybe row number?
Okay @RezaRaoofi and@Lynn Thank you very much. I’ll try setting a sort order.
@RezaRaoofi Hi, I tried setting up a sort order (well, I actually used the _RowNumber, Ascending as I thought that’s the easiest for my requirement), but still the CSV is generated in a very random order. Would like your help here! Thanks.