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!

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!

Hi Kaudia,

its simpler than it looks.

1) Click on the 'switch to advanced editor' link

2) in the expression line, wrap what ever is there with the inSameAttributeValue function, just like in the example.  Whatever you have there already goes inside a set of parentheses.  Just like the example, it goes within some double quotes: "inSameAttributeValue(yourFunctionHere)"

3) click save

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!

Hi Gino,
in the meantime I succeeded in building up an advanced query in DVF. I was struggling with the fact that the function "inSameAttributeValue" needs two parameters...
Thanks a lot for your help!

Hi Kaudia,

its simpler than it looks.

1) Click on the 'switch to advanced editor' link

2) in the expression line, wrap what ever is there with the inSameAttributeValue function, just like in the example.  Whatever you have there already goes inside a set of parentheses.  Just like the example, it goes within some double quotes: "inSameAttributeValue(yourFunctionHere)"

3) click save

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!

One addition:

I get this error but can save it and it also works. What's wrong in my expression?

Hi Gino,
in the meantime I succeeded in building up an advanced query in DVF. I was struggling with the fact that the function "inSameAttributeValue" needs two parameters...
Thanks a lot for your help!

Hi Kaudia,

its simpler than it looks.

1) Click on the 'switch to advanced editor' link

2) in the expression line, wrap what ever is there with the inSameAttributeValue function, just like in the example.  Whatever you have there already goes inside a set of parentheses.  Just like the example, it goes within some double quotes: "inSameAttributeValue(yourFunctionHere)"

3) click save

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!

Hi Klaudia,

I was no able to reproduce the error.  This points to either a hidden character (space at beginning or end?) or some kind of system glitch.  

If you are sure there are no hidden characters, I would delete and recreate the rule.

Hope that helps.

gino

One addition:

I get this error but can save it and it also works. What's wrong in my expression?

Hi Gino,
in the meantime I succeeded in building up an advanced query in DVF. I was struggling with the fact that the function "inSameAttributeValue" needs two parameters...
Thanks a lot for your help!

Hi Kaudia,

its simpler than it looks.

1) Click on the 'switch to advanced editor' link

2) in the expression line, wrap what ever is there with the inSameAttributeValue function, just like in the example.  Whatever you have there already goes inside a set of parentheses.  Just like the example, it goes within some double quotes: "inSameAttributeValue(yourFunctionHere)"

3) click save

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!

Hi Gino,
I did as you proposed and followed the syntax (blank or not) as described in the documentation, but still I get this error:


But it is so weird, that the DVF works correctly.

Kind regards
Klaudia

Hi Klaudia,

I was no able to reproduce the error.  This points to either a hidden character (space at beginning or end?) or some kind of system glitch.  

If you are sure there are no hidden characters, I would delete and recreate the rule.

Hope that helps.

gino

One addition:

I get this error but can save it and it also works. What's wrong in my expression?

Hi Gino,
in the meantime I succeeded in building up an advanced query in DVF. I was struggling with the fact that the function "inSameAttributeValue" needs two parameters...
Thanks a lot for your help!

Hi Kaudia,

its simpler than it looks.

1) Click on the 'switch to advanced editor' link

2) in the expression line, wrap what ever is there with the inSameAttributeValue function, just like in the example.  Whatever you have there already goes inside a set of parentheses.  Just like the example, it goes within some double quotes: "inSameAttributeValue(yourFunctionHere)"

3) click save

I don't know what exactly to enter in the "Advanced query editor" line. It has to be in JSON format as I see in the documentation. Could you please tell me the JSON expression which is for my condition (see screenshot) suitable? So, that it checks every value of the attribute "ProSA ID" and not only one. Thanks!

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!