Thanks Amanda for the confirmation.
I'm not 100% sure I understand where you are coming from but I am assuming that the data has one row per donor and then 50+ columns of interests.
The way that I do this is to "flatten" the data so that each row represents just one ConsID/Interest pair.
For example, if I start with
Once the data is like this then a simple IOM profile can import all of the different interests.
I need to add our prospect interest table entries (56 of them) to several records. Is there a way to do this without mapping every entry in IOM configuration? I'm hoping for some kind of virtual field or a cut and paste shortcut. If not, I'll have to do it the old fashioned way and manually enter them all on each record.
Thank you, in advance, for any ideas.