Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thank you, Rob. I'm unfamiliar with MAP statements. Does it matter where I insert those on the data 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...