Skip to main content

Hi 

 

I want to search for a validation message on a field.

For example if ABN is empty I can use Advance condition to write: ABN is null

 

However in this case I want to search where the ABN contains a value which has a validation message attached to it, ie where an ABN field is detected to be incorrect as it contains either a dummy value, or it didnt pass a check.

 

Usually these fields will be highlighted as they were scored higher in the cleanse layer in One Desktop

 

For example ABN is 0000000000 at the source layer

 

Is there a way I can search / filter records for their specific validation messages, as opposed to the content in the field. ( As the validation messages are not the actual input in the field, but score and explain what is wrong in the field)

 

See photo attached

thanks

 

 

hi! If what you want to do is filter a column based on the dq results rule failure, failure score, or failure description, what you could do is import the catalog item to ONE data (with dq eval results), once there, you can click on the filter button and a filter records box will appear.

  1. Select the column you will be checking the rules against, then in the middle box where we have the operator, scroll all the way until you see “failed”, click failed.
  1. Then you will have a new box that says “dq rules” available.
  2. There you can either filter by the DQ score or filter by the dimensions or rules / rule description (error message).

So, if you are specifically looking for a validation message that says “duplicate id” you would select the uniqueness dimension or the “id uniqueness” dq rule for example. If you want more granularity, you could click the little arrow next to the DQ rule, and it will show the conditions (with the error message like IS_INVALID for example) which you could then select from and it will filter depending on that validation description, I believe this is the closest to achieving your mentioned goal :)

 

 

Hope this helps!!

I believe the original question is about MDM. For MDM usually there is an explanation column that serves as a source for these messages.
For example, in here there is PID (exp) column that holds explanation codes for the PID

You can easily filter by this column. One important note though: these columns can hold multiple explanation codes separated by spaces, so to filter properly, you should use the "contains" function.
 

 

Hi @mauriceK, I’m closing this thread for now, if you have any follow up questions please don’t hesitate to share in the comments or create a new post 🙋‍♀️

Thanks all for your responses. Have a great day

Reply


Community Terms of Use & ConditionsCookie settings