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