Skip to Content
Former Member
Mar 11, 2010 at 03:42 PM

How to determine an attribute from a range table automatically



I am using MDM 7.1. I have a business requirement an attribute is not specific by record, but by a range of records. The example is that I need to load GL accounts and that the GL account number determines the attribute value from a range of GL account numbers. For instance the range 03520000 - 03529999 all share the same attribute (for instance 'cash').

When a user creates a record for 03520010 then the requirement is that the value 'cash' is automatically assigned, because 03520010 falls withing this range. How would one do this using MDM?

Thanks very much.

Bernard Fidder