topic Re: Change values in the load in QlikView

Change values in the load

Anonymous — Mon, 05 Aug 2013 08:18:32 GMT

Hi all,

I load several csv.-files and store them into one qvd.

Now I have the problem that there is one row (Town), which has many times two wrong values.

Town:

FFM

I want to change them like:

Town:

Munich

Frankfurt

Is this in the load possible?

Thank you for helping!

Re: Change values in the load

fdelacal — Mon, 05 Aug 2013 08:26:52 GMT

You can use qcViewer.

you cna change data and name fields.

This is the website to free download.

http://easyqlik.com/download.html

Hope that helps.

Re: Change values in the load

tresB — Mon, 05 Aug 2013 09:02:27 GMT

try something like this:

map1:

mapping load * inline [

x, y

M, Munich

FFM, Frankfurt

] ;

TabelName:

Load

ApplyMap('map1' , Town) as MappedTown

From ....;

Re: Change values in the load

Mon, 05 Aug 2013 09:05:20 GMT

try to use

pick(match(Town,'M','FFM'),'Munich','Frankfurt') AS TOWN_NEW

Re: Change values in the load

Mon, 05 Aug 2013 09:10:59 GMT

TRY THIS

maptable:

mapping load * inline [

X, Y

M, Munich

FFM, Frankfurt

] ;

MAP Town using maptable;

load * inline [

Town

FFM

] ;

Re: Change values in the load

MayilVahanan — Mon, 05 Aug 2013 09:15:25 GMT

Try like this

Load If(match(Town,'M','FFM'), Pick(match(Town,'M','FFM'),'Munich','Frankfurt'), Town) as Town;

Load * Inline

[

Town

FFM,

Others

];

hope that helps