cancel
Showing results for 
Search instead for 
Did you mean: 

need help with "Calculation Express"

Former Member
0 Kudos

Hello! MDM Experts -

Need help writing the formula using the expression editor on a calculated field to do some lookups and fill the value of a field as mentioned below.

Example: If the field value "AddressName" on main table matches the field value "Lookup1Name" in lookup table "Lookup1" at the time of data load (via import manager), then fill the field "AddressCustomerNo" on the main table with "Lookup1CustomerNo" from the "Lookup1" table.

If the value is "Null" or the doesn't match, then do nothing (skip).

All the fileds are type "Text". MDM Version 5.5 SP06 (5.5.63.57).

Look forward to hearing on any creative ideas/solutions. Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Nagarjuna,

There are two ways to achieve this requirement.

1. Using Calculated Field

2. Using Assignment and Workflow

Expression would remain same in both the cases:

IF(AddressName=Lookup1.Name, Lookup1.CustomerNo,[NULL])

Note: Dont type any thing,select the fields from the drop down list

Regards,

Jitesh Talreja