Skip to main content
Topics#Tableau Desktop & Web AuthoringNohemi West-Phelps の質問
Nohemi West-Phelps が「#Tableau Desktop & Web Authoring」で質問
2022年1月5日 19:14

I am trying to build a calculated field with case statement using a wild card but it doesnt seem like % works in tableau.

If the field called Investor contains CHFA anywhere in the string then return 'CHFA' and so on,...

 

CASE [Investor]

  WHEN  '%CHFA%' THEN 'CHFA'    

  WHEN '%FNMA-%' THEN 'BNYMellon'

  WHEN '%FHLMC-%' THEN 'BNYMellon'

  WHEN  '%GNMA-%' THEN 'USBank'

  WHEN '%MonitorOnly-%' THEN  'CHFA'

   WHEN  '%DMI-%' THEN  'DMI'

  END

4 件の回答
  1. DIEGO FERNANDO MARTINEZ RODRIGUEZ (Modux)
    2022年1月5日 19:31

    Hi, in this case you can use contains:

    IF  CONTAINS([Investor],'CHFA') THEN 'CHFA'    
    ELSEIF CONTAINS([Investor],'FNMA-') THEN 'BNYMellon'
    ELSEIF CONTAINS([Investor],'FHLMC-') THEN 'BNYMellon'
    ELSEIF CONTAINS([Investor], 'GNMA-') THEN 'USBank'
    ELSEIF CONTAINS([Investor],'MonitorOnly-') THEN  'CHFA'
    ELSEIF CONTAINS([Investor],'DMI-') THEN  'DMI'
    END

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego

    Tableau Ambassador

回答を記入...
0/9000