Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Did you try my suggestion?
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
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
];
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
we can't use where clause?
Did you try my suggestion?
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],
Hi,
PFA,
May be it wil match with your req.
Tnx a lot sir
s I have applied both suggestion and both are working