Changing Data Point across whole app in Load Editor

[p_nchl]

Hi there,

I am pretty new to Qlik and need to change the name of a data point across my entire app. Several different files that I uploaded used the country name "Cape Verde Islands" but I need to be using "Cape Verde". Rather than go through all of the files to manually change the name I am hoping that I could use an if statement or something to change the data in the load editor.

I am having trouble figuring out how to get that done, though.

Thanks in advance for your help!

[dplr-rn]

Is it just 1 value? Why not use an if statement in your load script to do the needful

[vishsaggi]

May be you want to use apply map like

Countrymap:
Mapping Load * INLINE [
CountryName, UpdateCountryName
Cape Verde Islands, Cape Verde
];

In your actual tables where ever you have this field [Country name]
change like

LOAD field1, field2,
ApplyMap('Countrymap', [Country name]) As CountryName
From yourtablename;

[rwunderlich · Accepted solution]

In this case it's probably easier to use a MAP statement than update each Load statement with ApplyMap().

Countrymap:
Mapping Load * INLINE [
CountryName, UpdateCountryName
Cape Verde Islands, Cape Verde
];

MAP  [Country name] USING Countrymap;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[vishsaggi]

Thanks Rob you are right completely missed that.

[p_nchl]

Thank you, Rob. I'm unfamiliar with MAP statements. Does it matter where I insert those on the data load editor?

[vishsaggi]

After Map using statement put all the other table loads. It would automatically convert the values.

[rwunderlich]

The MAP USING statement will apply to all subsequent loads.  So put it anywhere before the LOAD statements.  I typically put it right after my MAPPING LOAD. 

Countrymap:
Mapping Load * INLINE [
CountryName, UpdateCountryName
Cape Verde Islands, Cape Verde
];

MAP  [Country name] USING Countrymap;

LOAD ....;

LOAD ...

JOIN...

LOAD...