Five Stars

Data Quality Profiling Use Case

Would TDQ be able to create an analysis and DQ report for columnC if the requirement was:

if columnA is not null

AND columnB between 

then columnC should not be blank

  • Data Quality
1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: Data Quality Profiling Use Case

I figured out one way...furthering the use case there is a table join that needs to happen. I was able to create a business rule on my final column of interest, add the logic in the where clause and create a join.  Then used a specific analysis that leveraged the business rules. I'll leave it open if there is another way too that someone has...

1 REPLY
Five Stars

Re: Data Quality Profiling Use Case

I figured out one way...furthering the use case there is a table join that needs to happen. I was able to create a business rule on my final column of interest, add the logic in the where clause and create a join.  Then used a specific analysis that leveraged the business rules. I'll leave it open if there is another way too that someone has...