Re-name column names in a field

[bharatkishore]

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

[Anonymous · Accepted solution]

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);

[pradosh_thakur]

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,

[stigchel]

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..

[bharatkishore]

Thaks Gareth,

My bad forget....

[bharatkishore]

Thanks Pradosh.

Thank you so much.. Thanks again...

[bharatkishore]

Thanks piet