I have a table in dataverse that was loaded from a csv file. The key column is 5 characters. When the column had a character in it, the key was loaded properly, with leading zeros to fill out to 5 characters. However, if it was numeric, the leading zeros were truncated. So 05520 was loaded as 5520. 055A0 was loaded properly as 055A0. I understand how that happened.
I need a way to correct the keys that are in error. it is causing lookup errors, as 05520 cannot be looked up in the table. Can you download the spreadsheet of items, update it, and reupload? will it update, or do I have to delete the table, and reload it properly?
