Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
p_nchl
New Contributor

Changing Data Point across whole app in Load Editor

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!

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Changing Data Point across whole app in Load Editor

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

7 Replies
dilipranjith
Honored Contributor

Re: Changing Data Point across whole app in Load Editor

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

Re: Changing Data Point across whole app in Load Editor

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;
MVP & Luminary
MVP & Luminary

Re: Changing Data Point across whole app in Load Editor

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
Esteemed Contributor III

Re: Changing Data Point across whole app in Load Editor

Thanks Rob you are right completely missed that.
p_nchl
New Contributor

Re: Changing Data Point across whole app in Load Editor

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

vishsaggi
Esteemed Contributor III

Re: Changing Data Point across whole app in Load Editor

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

Re: Changing Data Point across whole app in Load Editor

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