Skip to main content
Solved

Custom Data quality check

  • August 12, 2022
  • 1 reply
  • 82 views

Forum|alt.badge.img+1

Can we create custom check on data as per our need and get stats out of it ??

for example.. I want to check whether colA has values between list [β€˜A’,’AB’,’O’,’B’] and stats about the values that are present in data.

Best answer by Anonymous

Hi @sd_2000 ,

Thank you for your question. 

Sure, you can create a DQ Detection rule which is used for detecting business term in Catalog Items.

To give you an example:

  1. Go to Web App β†’ navigate to section Data Quality β†’ DQ Detection Rules and click on Create in the upper right corner

     

  1. Fill in name (required) and other fields (if needed)
  1. Go to Implementation tab 
  1. Add a new attribute and select a logic type detection in the section Rule Logic
  1. Change the condition type to Advanced Expression and write an expression, for our example we have used upper(input_blood_group) is in {β€˜A’, β€˜B’, β€˜AB’, β€˜0’} to detect values A, B, AB and 0

  1. Test the rule to see that it’s working as desired
  1.  Publish

Hope it helps. 

View original
Did this topic help you find an answer to your question?

1 reply

  • 0 replies
  • Answer
  • August 15, 2022

Hi @sd_2000 ,

Thank you for your question. 

Sure, you can create a DQ Detection rule which is used for detecting business term in Catalog Items.

To give you an example:

  1. Go to Web App β†’ navigate to section Data Quality β†’ DQ Detection Rules and click on Create in the upper right corner

     

  1. Fill in name (required) and other fields (if needed)
  1. Go to Implementation tab 
  1. Add a new attribute and select a logic type detection in the section Rule Logic
  1. Change the condition type to Advanced Expression and write an expression, for our example we have used upper(input_blood_group) is in {β€˜A’, β€˜B’, β€˜AB’, β€˜0’} to detect values A, B, AB and 0

  1. Test the rule to see that it’s working as desired
  1.  Publish

Hope it helps. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings