MDM Assignment

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Christian,

I am not trying to run the assignment on the qualified table. I am trying to create a material from Data manager in Products table and I need to run this assignment with the condition mentioned.

Cheers,

Korobee

[Former Member]

Hi Korobee,

to rephrase, assignments cannot be run on qualified tables (from main tables). You can have several locations, i.e. entries in the qualified table, but MDM is not able to identify corresponding loading and checking groups for each location.

My recommendation is the following: When you create a material, you create location data. In location data the users enters a loading group. The checking group is then filled automatically through a calculated field that sets the code depending on the loading group. You can also use the name, but I assume that you will syndicate the material record afterwards and then you will most likely need a code. The only problem is that the user will not be able to change it afterwards.

If you know that you have only one location, then you can also create the fields loading group and checking group directly in the main table.

I hope I'm a bit clearer now. Let me know if you need more information or I misunderstood your requirement.

Best regards

Christian

[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