how to rename inside the field data?

[daisy1438]

Hi I have field  [Geography] and data like

[Geography]

canada

europe

america

usa

MENAT

My requirement is change the rename in above data like

MENAT to "'Middle East" and USA to 'United States'.

how to change this. And it is possible to change in front end level. actually  I am using Geography field for filter.

Thanks

[justinphamvn]

Hi,

Try this:

Script load data:

LOAD

    ...

,if([Geography] = 'MENAT', 'Middle East', if([Geography] = 'usa', 'United States', [Geography] )) as [Geography]

...

Hope this helps,

Justin

[Anonymous]

Hi

In front end  you can use replace function for each region in calculated dimension

replace(Geography,'MIDDLE EAST','MENAT')

But rather doing this you can apply MAPPING in back end.

Thanks

[raman_rastogi]

Or You can use inline Load table with Geography and changed name,map that table with your data model.

ex-

LOAD * INLINE [   

    Geography, ChangedName  

    UK,        United Kigdom

    usa,       United States   

    MENAT,     Middle East

]

Regards

Raman

[jonathandienst]

Create a mapping table (inline below, but it could be stored in a file or database) and then applymap in the corrections:

MAP_GEOGRAPHY:

Mapping

LOAD * INLINE [  

    Geography, ChangedName 

    UK,        United Kigdom

    usa,       United States  

    MENAT,     Middle East

];

// LOAD Main table containing Geography field:

Main:

LOAD

    ...

    ApplyMap('MAP_GEOGRAPHY', Geography, Geography) as Geography,

    ...

[jagadeeshbv29]

not working me  can you tell another way