Multiple Condition

[Karim_Khan]

HI Team,

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

EMEAR - OTHER

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 for category IOT.

If I Select category  IOT then it should pick the remaining 4 Value

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - NORTH

EMEAR - UK

And If I Select category  IOE then it should pick the remaining 5 Value.

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - NORTH

EMEAR - UK

EMEAR - OTHER

Regards,

KK !

[Karim_Khan]

I am trying to achieve the above requirment by belwo script

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' ,

     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

But its satisfying 1 requirement taking 4 values not other requirement

Reagrds,

KK

[jonathandienst]

You could load it much like this. Just convert from the inline to an XLS load:

LOAD SalesLevel1,

  If(SalesLevel2 = 'Emerging', 'Emerging', 'Europe') As SalesLevel2,

  SalesLevel2 As SalesLevel3

Inline

[

SalesLevel1, SalesLevel2

EMEAR,CENTRAL

EMEAR,SOUTH

EMEAR,EMERGING

EMEAR,NORTH

EMEAR,UK

EMEAR,OTHER

];

[gautik92]

IOT Map

Mapping Load

EMAR-REGION,

if(Match(EMEAR-REGION,'EMEAR - CENTRAL','EMEAR - SOUTH','EMEAR - NORTH','EMEAR - UK')>0,1,0)  as IOTMapping

from

use it in ApplyMap

IOEMap:

Mapping Load

EMAR-REGION,

if(Match(EMAR-REGION,'EMEAR - CENTRAL','EMEAR - SOUTH','EMEAR - NORTH','EMEAR - UK','EMEAR - OTHER')>0,1,0) as IOEMapping

from

[Karim_Khan]

we can't use where clause?

[jonathandienst · Accepted solution]

Did you try my suggestion?

[sasiparupudi1]

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

[#8]

Hi,

PFA,

May be it wil match with your req.

[Karim_Khan]

Tnx a lot sir

[Karim_Khan]

s I have applied both suggestion and both are working