Solved

Custom Data quality check

  • 12 August 2022
  • 1 reply
  • 78 views

Badge

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.

icon

Best answer by Anonymous 15 August 2022, 14:08

View original

1 reply

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