Skip to Content
avatar image
Former Member

MDM Assignment

Hi All,

Can anyone please help me with the MDM assignment. I have a field Location Data which is qualified flat in main table. Now within location data there are two fields Loading Group and Checking Group which are flat lookups. Loading group and checking group has fields code and name. Now my condition should be like this:

If loading group.code = ab or cd then checking group.code = 12 else if loading group.code = ef then checking group.code = 34.

Can anyone please help me in writing this assignment.

Thanks for your time.

Cheers,

Korobee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 05, 2011 at 03:52 PM

    Hi Korobee,

    unfortunately, MDM does not allow you to use assignments in qualified tables nor in tuples. A workaround may be to use calculated fields for checking group.

    Best regards

    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Korobee,

      I would like to add here, Qualified tables have limited validation and assignment functionality. By this I mean You can very well write an expression as per requirement said above but the thing is when you run this Assignment expression based on condition. It works well for Qualified table if it has Single qualified link. But if your Qualified table has more than one qualified links for your main table single record it will fail. As Qualified table usually contains more than single record for main table record and thus will give you in-consistent results. Because for multiple qualified links(records) Expression checks Condition for 1st qualified record only and does not check for other qualified links.

      e.g. If your main table record has qualified table and this qualified table has three qualified links(records) then it will check only for 1st qualified link not for 2nd and 3rd.

      So unfortunately, Creating a material in Products table by running this Assignment Expression is not feasible if your qualified table has more than 1 qualified links for single main table record.

      Regards,

      Mandeep Saini