How to determine an attribute from a range table automatically

[Former Member]

Hi,

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

[Former Member · Accepted solution]

You can run Assignment to fulfill this requirement in mdm.

Say you have two fields in your main table of mdm data manager as GL Account No and AssignField.

Create an Assignment and assign Assignment Field as AssignField.

Write assignment expression as given below:

IF(GL Account No >= 03520000 AND GL Account No <=03529999, "Cash", *as per you requirement)

*as per your requirement = You can either here populate GL Account No or can specify again any IF condition for another range and so-on)

Kindly revert with the result and let me know if you have any issue in creating assignment expression.

It is working fine at my end.

Note: For assigning this value automatically, you can include this assignment in work-flow and set work-flow property Set trigger action on Record Add and Record Import.

Thanks and Regards,

Mandeep Saini

[Former Member · Accepted solution]

Thanks very much, Mandeep,

This has been helpful. But instead of wanting to document the ranges in the code of the Assignment, I want to store these ranges in a table in MDM. For instance, "0352000 - Cash", "0353000 - Bank". In that way I should be able to read the table and find the nearest lower key, which then will tell me what the attribute is for the account.

So my question is really: Can I access this table in this way from an Assignment in MDM?

Thanks and regards,

Bernard Fidder