I have imported a file in CSV format, and I have two questions about the created table:
1、The column (id) in the csv file will also be imported, so there will be two columns showing serial numbers, and the order is different. Can this situation be avoided? I just want one column to represent the serial number
2、If I export a file and import it again, the picture will not be displayed normally. Is it the URL of the picture? How can I make the picture display properly after importing?
1、The column (id) in the csv file will also be imported, so there will be two columns showing serial numbers, and the order is different. Can this situation be avoided? I just want one column to represent the serial number
The reason why that is happening is because when you run an export it will export the data in the same order you can currently see in your view. So if you have applied sorts or filters it will leave out every entry that was filtered out and it will order the exported csv by the sort that you have applied.
On the other hand, when you then import the CSV it will just assign ids in the order that the data was inserted, the new ID is not inferred from the exported ID.
In my opinion, a neat feature we could add, is to add a dropdown to the import saying something like Infer row Id from field X where you can select the exported ID field for example and turn that into your new IDs.
Hi @Alex ,thanks to your explanation, I know why the order of the two columns is different.
In fact, I don’t need to automatically generate the id 2 column. When I import a csv file to create a table, the table will always automatically generate a column (id 2). I don’t want to generate this column when importing. Can I do this?