I have ~300k responses to my survey today that are tied to a location ID. The location ID is collected in two different fields, one from the query string in an email invite. The other from a text box field on the first page of the survey.
I have to switch my data values for the location ID to now have leading zero’s up to 4 digits. So location 6 would now need to be 0006, or 24 would need to be 0024. All of my data collected starting next year will be collected with the leading zeros. I want to make sure my historical data and my new data all match, so I need to add leading zeros to the old data.
I can’t just export, add leading zeros and then import because that will create all new records and not update the existing records. I don’t want to delete the old records and then reupload because that will count against my total interactions.
I’m trying to not add additional embedded data fields, mostly because it’s fairly messy with a lot of embedded data already, so I’m hoping there is some way that I can easily solve this by simply manipulating the data that I haven’t considered yet.
