1 Reply Latest reply on Jul 30, 2018 11:21 AM by Hari Ankem

    How to Convert this sql piece to Tableau field

    Surap Nami

      Hi,

       

      I'm new to tableau, and this is my first project. How would I convert this sql to tableau. I'm confused with IF, else if, iif.

       

      select  case when RD = 1 then 'RD' 
                   else 
                   case when Status <> 'Publish' and subro_only = 0 and SIU=0 then 'Open' 
                                        when Status = 'Publish' and subro_only = 0  and SIU = 0 then 'Publish'
                                        when SIU = 1 then 'SIU'
                                        else 'Sub'
                           end
                    
                 end  as ClaimStatus