I’ve done an export from our website and want to import into Airtable. Most of the fields are fine but there is one field that I’d like to import as a Multi Select field but having issues.
A sample of the (anonymised) data looks like:
Apple~Chicken, Beef & Lamb~Rice~Pasta~Banana
Crisps, Chocolate and Sweets~Smoothie~Pineapple
Cheddar & Stilton~Pancakes
Crisps, Chocolate and Sweets~Pasta
For the above records I’d like them to appear as:
There are around 50 variables for the multi select field and the data itself is around 10,000 records so want to get the import right! And whilst we are looking at the API for the future, in the short term we will have to do multiple imports to keep the data up to date.