can we use case statement

[Karim_Khan]

Hi Team,

  can we use case statement in script or Expression?

I have the two Sales Level 1 and Sales Level 2.

In Sales Level 1 I have Field EMEAR-REGION which is mapped to Sales Level 2 value i.e

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - EMERGING

EMEAR - NORTH

EMEAR - UK

But in above Field If I select EMAR-REGION then it should directly associate to EMEAR - EMERGING

and I want to create one more Field with name EUROPE in Sales Level 2 which should directly pick the remaining 4 fields.

Regards,

KK !

[gautik92]

Cisco:

LOAD [End Customer Global Ultimate Name],

     Country,

     [End Customer HQ Top],

     [Sales Level 3],

     [Sales Level 4],

     [Sales Level 5],

     [Partner Name],

     [Fiscal Period ID] as Fiscalid,

     [Net Bookings],

     CATEGORY ,

     If([Sales Level 2]='EMEAR-EMERGING','EMEAR-REGION'  as aliasname,

     If(Match([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI') AND MATCH([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI','EMEA OTHER'),'EUROPE',[Sales Level 1]))  as [Sales Level 1],

     [Sales Level 2]

FROM

[Karim_Khan]

Its not working

[gautik92]

post sample data