I have data collection with 7 fields of data, Title, Height, Width.. and one field is a photo image. I want to add one more column of data from a csv file.
So I exported the data from the WIX dataset and included the item ID's.
In the import csv file, I include the dataset WIX ID and the new column of data. There are 2 options when you import data from a csv file, 1. replace with imported data and 2. do not import.
If I select replace with imported data and import the ID and the new column data, the result is all my existing data fields are cleared out and I have a dataset with one column, the new one I imported.
If I select, do not import, the new column of data is not imported
How do I import a new column of data to an existing dataset without clearing out the existing data in the existing fields.