- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2025 05:03 AM
Hi shubham_007,
How are you doing today? Sorry for the delay. Thanks for sharing those column details—they’re perfect for building meaningful data quality checks! For fields like Date of Admission and Discharge Date, you can use SQL expressions in DQX to check if the date is valid, within a realistic range, older than a certain number of days, or not in the near future. For example, you can write a rule like "sql_expression": "datediff(current_date(), DateOfAdmission) > 7" to check if the date is more than 7 days old. For Billing Amount, a good check could be something like "sql_expression": "BillingAmount >= 0 AND BillingAmount < 100000" to make sure the value isn’t negative or unusually high. And for Medical Condition, you can use a regex to allow only letters and spaces, like "sql_expression": "MedicalCondition RLIKE '^[A-Za-z ]+$'". Make sure to test these expressions in a notebook before adding them to your YAML file, and watch for proper indentation and quotation—YAML can be fussy! Let me know if you’d like me to help write a sample YAML file using these rules—I’d be glad to help.
Regards,
Brahma