I’m just getting started, so thanks in advance for any help on this.
I’ve got some data I’m importing from a spreadsheet, where there is a field called Codes, which has multiple values separated by commas. (There are no commas in the values themselves.) I would like to do separate out each value, and have the values become choices chosen in a set-type attribute for that note. Each note will have a different combination of one or more values, some of which may appear on more than one note.
For example, while the Code for one particular note originally is =“modularity: effort to design, modularity: miniaturization of technology” (one value), I would prefer it to be Code=“modularity: effort to design, modularity: miniaturization of technology” where the Code attribute is a set… something like this (here I just added the suggested values by hand):
How can I automate this process as I import more notes (which may have new values)?