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
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
- 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.