How can we write case statements in Ataccama one web DQ rules?
As of now we are writing multiple conditions with distinct invalid statements. I am looking for a better approach rather than going the traditional way.
Thanks,
Mahesh
Solved
Case statement in Ataccama one web DQ rules
- Data Pioneer
- 6 replies
Best answer by MayKwok
Hi Mahesh,
ONE Web DQ Rules is actually a giant case statement put in a web form that should be more business user friendly, the principle is:
If Condition 1 is met, then “invalid” (with Reason 1), else
If Condition 2 is met, then “invalid” (with Reason 2), else… (define as many conditions as you want here… until)
Valid
If you prefer to use more expression-like language, have you had a play with using the Advanced Expression box in the rule condition configuration?
Within a rule condition, you can also use our case() or iif() functions.
Hope this helps?
- Data Pioneer L2
- 16 replies
- Answer
Hi Mahesh,
ONE Web DQ Rules is actually a giant case statement put in a web form that should be more business user friendly, the principle is:
If Condition 1 is met, then “invalid” (with Reason 1), else
If Condition 2 is met, then “invalid” (with Reason 2), else… (define as many conditions as you want here… until)
Valid
If you prefer to use more expression-like language, have you had a play with using the Advanced Expression box in the rule condition configuration?
Within a rule condition, you can also use our case() or iif() functions.
Hope this helps?
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.