I am trying to use CsvImport to map multiple values to elements in CsvImport. In my CSV file, it might say:
John,27,"Jack, Gill, Robert",
Here, I would like the first Item record to have three separate Friend element/value pairs, and the second Item to have two.
What's currently happening is that I end up with a single Friend element containing the text "Jack, Gill, Robert" in the case of the first Item, for example.
I can map these values to separate Items tags easily enough, although this is not what I want.
Is what I am trying to do possible? And if so, is there something I am overlooking here?