Join 3 fields in a Dimension and call num 1?

[#1]

Hello Experts,

I have the below load script and I am trying to add the values associated to 'Opportunity - Dead' , 'Lead - Open', 'Opportunity - Tracking' as 1. I want to join all the values associated with this Status types and call them 1 so I can use them further for charts. Not sure how to do it?

Load

Status,

if(Status='Opportunity - Dead',1,
    if(Status='Lead - Open',1,
    if(Status='Opportunity - Tracking',2,
    if(Status='Opportunity - Developing',3,
    if(Status='Opportunity - Pipeline',4,
    if(Status='Opportunity - Priority',5,
    if(Status='Opportunity - Portfolio',6,)))))))             as From XYZ Table;

Thanks in Advance,

Mady

[deepakk · Accepted solution]

hi,

Here you go...

if(Status='Opportunity - Dead'  or Status='Lead - Open' or  Status ='Opportunity - Tracking',1,

    if(Status='Opportunity - Tracking',2,

    if(Status='Opportunity - Developing',3,

    if(Status='Opportunity - Pipeline',4,

    if(Status='Opportunity - Priority',5,

    if(Status='Opportunity - Portfolio',6,))))))

I hope this helps.

Deepak