How to add one new (column) field to a data collection

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.

1 Like