Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this:
Script load data:
LOAD
...
,if([Geography] = 'MENAT', 'Middle East', if([Geography] = 'usa', 'United States', [Geography] )) as [Geography]
...
Hope this helps,
Justin
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
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
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,
...
not working me can you tell another way