Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field called Market.
In Marketi have NA and UKI etc.
My requirement is in place of NA i should get North America and in place of UKI i should get UK & Ireland.
Can you please help me how to get this.
Attached app for reference.
Thanks,
Bharat
Add an if statement in your load script on the Market field. This will ensure user performance is not affected;
Target:
LOAD Cluster,
Country,
Denominator,
Entitlement,
GSS,
KPIScope,
if(Market = 'NA', 'North America', if(Market = 'UKI', 'UK & Ireland', Market)) as Market,
Upper(pick(MATCH(Region,'ANZ','SEA','Korea','Indonesia')+1,Market,'Australia & New Zealand','South East Asia','Korea','Indonesia' )) as Market_Tgt,
Metric,
MG,
Modality,
Numerator,
Period,
Region
FROM
(qvd);
Add an if statement in your load script on the Market field. This will ensure user performance is not affected;
Target:
LOAD Cluster,
Country,
Denominator,
Entitlement,
GSS,
KPIScope,
if(Market = 'NA', 'North America', if(Market = 'UKI', 'UK & Ireland', Market)) as Market,
Upper(pick(MATCH(Region,'ANZ','SEA','Korea','Indonesia')+1,Market,'Australia & New Zealand','South East Asia','Korea','Indonesia' )) as Market_Tgt,
Metric,
MG,
Modality,
Numerator,
Period,
Region
FROM
(qvd);
pick(MATCH(Region,'ANZ','SEA','Korea','Indonesia')+1,pick(match(Market,'NA','UKI')+1,Market,'North America','UK and Ireland'),'Austrailia and Newzeland','South east asia','Korea','Indonesia')as Market,
A mapping load and applymap is best for this:
Market:
Mapping Load * Inline [From, To
UKI, 'UK & Ireland'
NA, 'North America'
];
LOAD
...
ApplyMap('Market',Market,Market) as NewMarket
...
From..
Thaks Gareth,
My bad forget....
Thanks Pradosh.
Thank you so much.. Thanks again...
Thanks piet