Order of rows when importing data

How to
#1

How could I change the order of data (order of rows) when I import data to a schema from an excel file? I’ve tried re-ordering the rows in the excel and adding a number column but these did not help.

I am trying to create a list of countries where the upper row is A and last row is Z. I know that the data can be re-arranged but I am using the list of countries in other schemas and having the user to re-arrange the data on the first use is not good.

Thanks!

#2

Hi Martti,
Default sort is by “created date” descending. While importing from excel, I am not sure, how the order is handled between components. Maybe, it would be better to mark one column as a default sort in schema items definition. We can put it into requirements.
Regards
Michal

1 Like