Greetings,
I want to convert the following column "BusinessRules provided in Tableau calculated field" values to TSQL and the rules are nearly 1000 rules.
Here is the sample data.
| BusinessRuleID | BusinessRuleName | BusinessRules provided in Tableau calculated field |
|---|---|---|
| 1 | Gender | CASE[Q3 Gender Multiple Choice Question]WHEN '1.Male' THEN 1 ELSE 0 END AND CASE [Q6S Smoke Multiple Choice Question]WHEN '1. Yes' THEN 1 ELSE 0 END |
| 2 | Subects | IF (ATTR([Market]) = Africa AND SUM([Sales]) > [Emerging Threshold] )THEN 1 Else 0 |
Thanks for your help in advance !!
indent preformatted text by 4 spaces