Reltio Connect

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!

Hi Klaudia,

I think you are observing this behavior because DVF rules, by default, apply to only ov:true values. However, you can change this behavior using the applyOn parameter. See the documentation below:

https://docs.reltio.com/en/objectives/cleanse-and-verify-data/data-cleansing-at-a-glance/data-cleansing-operation/define-data-validation-functions/apply-data-validation-functions-at-crosswalk-level

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!

Thanks Snehil for your answer.

I only want to apply the DVF on operational values. I have an attribute which may store several values, all are OV. The validation check should run on all these different values and throw an error if at least one does not fulfill the regex.

Hi Klaudia,

I think you are observing this behavior because DVF rules, by default, apply to only ov:true values. However, you can change this behavior using the applyOn parameter. See the documentation below:

https://docs.reltio.com/en/objectives/cleanse-and-verify-data/data-cleansing-at-a-glance/data-cleansing-operation/define-data-validation-functions/apply-data-validation-functions-at-crosswalk-level

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!

I believe that is the expected behavior.  If its not working that way for you, I'd suggest submitting a ticket to support

Thanks Snehil for your answer.

I only want to apply the DVF on operational values. I have an attribute which may store several values, all are OV. The validation check should run on all these different values and throw an error if at least one does not fulfill the regex.

Hi Klaudia,

I think you are observing this behavior because DVF rules, by default, apply to only ov:true values. However, you can change this behavior using the applyOn parameter. See the documentation below:

https://docs.reltio.com/en/objectives/cleanse-and-verify-data/data-cleansing-at-a-glance/data-cleansing-operation/define-data-validation-functions/apply-data-validation-functions-at-crosswalk-level

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!

In the Reltio documentation I already found this explanation, but I don't know how to apply it in the Advanced Editor of my DVF.

I believe that is the expected behavior.  If its not working that way for you, I'd suggest submitting a ticket to support

Thanks Snehil for your answer.

I only want to apply the DVF on operational values. I have an attribute which may store several values, all are OV. The validation check should run on all these different values and throw an error if at least one does not fulfill the regex.

Hi Klaudia,

I think you are observing this behavior because DVF rules, by default, apply to only ov:true values. However, you can change this behavior using the applyOn parameter. See the documentation below:

https://docs.reltio.com/en/objectives/cleanse-and-verify-data/data-cleansing-at-a-glance/data-cleansing-operation/define-data-validation-functions/apply-data-validation-functions-at-crosswalk-level

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!

that's great!  I thought that was the default config now.

but i'm unclear what assistance you need.  Getting to the advanced editor is a function of clicking on the 'switch to advanced editor' link visible in your screenshot above

In the Reltio documentation I already found this explanation, but I don't know how to apply it in the Advanced Editor of my DVF.

I believe that is the expected behavior.  If its not working that way for you, I'd suggest submitting a ticket to support

Thanks Snehil for your answer.

I only want to apply the DVF on operational values. I have an attribute which may store several values, all are OV. The validation check should run on all these different values and throw an error if at least one does not fulfill the regex.

Hi Klaudia,

I think you are observing this behavior because DVF rules, by default, apply to only ov:true values. However, you can change this behavior using the applyOn parameter. See the documentation below:

https://docs.reltio.com/en/objectives/cleanse-and-verify-data/data-cleansing-at-a-glance/data-cleansing-operation/define-data-validation-functions/apply-data-validation-functions-at-crosswalk-level

Hi,

I have created a DVF with a regular expression. It works fine.


But the attribute may have multiple values. So, the DVF should already throw an error if at least one of the values does not match the regular expression. But it does not behave like this.

How to configure it?

What exactly do I have to enter in the "Advanced query editor" which shows me only a single input line:

Thanks in advance for your help!