If Statement

[Anonymous]

Hi All

I am trying to create an IF Statement

if (StatusDesc = 'BI: BAU - PRIORITY',1),

  if (StatusDesc = 'BI: DEV - PRIORITY',2),

  if (StatusDesc = 'BI: SALES - PRIORITY',3),0 as PriorityStatus,

what am i doing wrong?

Thanks All

Adil

[Anonymous · Accepted solution]

try this:

if (StatusDesc = 'BI: BAU - PRIORITY',1,

  if (StatusDesc = 'BI: DEV - PRIORITY',2,

  if (StatusDesc = 'BI: SALES - PRIORITY',3))) as PriorityStatus,

[Anonymous]

Thanks Balraj for quick and correct response!

[tamilarasu]

Try any one of this method,

Pick(Match(StatusDesc, 'BI: BAU - PRIORITY','BI: DEV - PRIORITY', 'BI: SALES - PRIORITY')+1,1,2,3,0) as PriorityStatus,

If (StatusDesc = 'BI: BAU - PRIORITY',1,

  If (StatusDesc = 'BI: DEV - PRIORITY',2,

    If (StatusDesc = 'BI: SALES - PRIORITY',3,0))) as PriorityStatus,

[#5]

if (StatusDesc = 'BI: BAU - PRIORITY',1,

  if (StatusDesc = 'BI: DEV - PRIORITY',2,

  if (StatusDesc = 'BI: SALES - PRIORITY',3,0

)))as PriorityStatus,

[Anonymous]

[Anonymous]

Thanks for the help

[Anonymous]

Thanks for the help