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
IF [RD]=1 THEN "RD"
IF [Status]<>"Publish" AND [Subro_only]=0 AND [SIU]=0 THEN "Open"
ELSEIF [Status] = "Publish AND [Subro_only]=0 AND [SIU]=0 THEN "Publish"
ELSEIF [SIU] = 1 THEN "SIU"