Start a new topic

Use two columns for lookup value

I'm bringing data over from Luminate Online and I'm having trouble populating the gift fund field in Raiser's Edge.  What needs to happen is the value in column A (say 1 and 2) will direct me to what dictionary I need to use to look up the value from column B.  This in turn will be the value I use for the gift fund description in RE.  So let's say column A is 1 then I need to use 'Dictionary 1' on column B for my value.  Otherwise (if column A is 2) I need to use 'Dictionary 2'  on column B for my gift fund description.  I haven't worked much with IOM so any help would be greatly appreciated.

Login or Signup to post a comment