Skip to main content

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.

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


ataccama
arrows
Lead your team  forward  OCT 24 / 9AM ET
×