Copy data from another column

Thomas Bonfils

Hey, i imported my old database from airtable but column name are wrong.

I saw if i rename it i loss all my data...

I create a new column with the good name, now i want to copy data from one column to another column.

I think i need to use for each loop, but i don't succeed to do this.

Thanks,
Thomas

David Richardson

Consider changing your airtable names to the correct ones.  
Export the updated airtable to CSV. 
Clear out the old data from the Xano table.  
Import the modified table.  

It might be "clunky" but I've done the same and decided it was the best solution. :-)  Be mindful your id's will now start where the old table left off.  Or delete the table altogether and start from scratch. :-(.

The Xano team might have a different solution but it might be much later today they post it here

Chris Coleman

 This sounds like a good plan. 's thought about using a loop would work too, but I think a CSV import would just be less steps, honestly.

Also, as an aside, we do offer an option when clearing all records in a table to reset the primary ID back to 1. [image.png]

David Richardson

Hey Chris
I did not see that.  Thanks