Hi All, Is there a particular reason why a CS...

(Malaka Jayawardene) #1

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?

#2

Good question I was just wondering that myself.

(Reza Raoofi) #3

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

#4

Or maybe row number?

(Malaka Jayawardene) #5

Okay @RezaRaoofi and@Lynn Thank you very much. I’ll try setting a sort order.

(Reza Raoofi) #6

You’re welcome!

(Malaka Jayawardene) #7

@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.

(Reza Raoofi) #8

@Malaka_Jayawardene

I have not tried sorting by _RowNumber myself; perhaps it has to be a different sort order.

Perhaps sort by _RowNumber is equivalent to “no sort order”.