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.

2. Then you will have a new box that says “dq rules” available.
3. 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