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.

Barbara

Thanks Amanda for the confirmation. 

Hi Barbara,

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

becomes

Once the data is like this then a simple IOM profile can import all of the different interests.