Validation Expression: Unique record by non-qualified value

[Former Member]

I have a Business Partner repository that contain a Qualifier Table "Tax Number Type". In the Main Table, I have a field typed qualified flat called "Tax Numbers".

The "Tax Number Type" table have the folowing fields:

Tax Number Type: Qualifier = NO - the values are: BR1, BR2, BR3, BR4.

Tax Number: Qualifier = YES

I need to verify if there are more than one value of the "Tax Number" in a record. For example:

Record 1 (correct)

-- Tax Numbers:

-

---

BR1, 123321

-

---

BR2, 988191

Record 1 (Error: BR1 is duplicated)

-- Tax Numbers:

-

---

BR1, 123321

-

---

BR1, 988191

How to do this validation in the MDM?

Thank you,

Evandro

[Former Member · Accepted solution]

Hi,

This is a default behaviour of Qualified tables and you cannot restrict this.

You can check the below thread of similar requirement

Regards,

Jitesh Talreja

[Former Member]

Hi Evandro ,

This is how Qualified table works in MDM.

The qualified tabel in MDM is always Multivalued and so it permits to have differnt combination of the same non qualifier with differnt qualifier values.

so you can have BR1 with 12345

and BR1 with 67890

It is difficult to restrict this combinations to only unique values using and validations as this is the default behaviour of Qualified table.

It aims to have a qualfier value depending on the non qualifier value but this is allowed to vary for every record.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Thank you. I will change my repository structure.