Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The variable [Sub-sector?] in the table 'fact_countries' contains different job titles that need to be graded according to their perceived Risk into: "High Risk", "Medium " and "Low Risk". Everything else goes into " not specified".
Why is the below code setting all varibles to High Risk?
Risk =
SWITCH(TRUE(),
CONTAINS(fact_countries, fact_countries[Sub-sector?],"Derivative issuer")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Derivatives issuer")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Derivatives issuerOther")
,"High Risk",
CONTAINS(fact_countries, fact_countries[Sub-sector?],"Fund manager")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Fund managerBrokers / Custodians")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Fund managerBrokers / CustodiansDIMS provider")
,"Medium Risk",
CONTAINS(fact_countries, fact_countries[Sub-sector?],"Issuer of securities")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Other")
|| CONTAINS(fact_countries, fact_countries[Sub-sector?],"Trustee corporation / Licensed supervisor")
,"Low Risk",
"Not specified"
)
Solved! Go to Solution.
I was wrong: IT WORKS. I leave it here for reference.
I was wrong: IT WORKS. I leave it here for reference.
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |