topic replacing the name in a table in QlikView

replacing the name in a table

Mon, 16 Mar 2015 13:28:47 GMT

Hi Experts,

i have the following table loaded from a qvd.

Target:

LOAD BDM,

[Branch Name],

LBDM,

TGT_YEAR,

FROM

QVD\TGT_YEAR.qvd

(qvd);

in the LBDM field, i have a list of names.

i need to replace the name Nick by Chris.

how can i do that.

any script changes?

please help me in this regard.

Re: replacing the name in a table

Mon, 16 Mar 2015 13:33:03 GMT

Hi,

This could easy be solved by using Applymap on the LBDM field to replace "Nick" with "Chris".

Good luck!

Re: replacing the name in a table

Mon, 16 Mar 2015 13:33:54 GMT

can u pls help me with the script?

Re: replacing the name in a table

stigchel — Mon, 16 Mar 2015 13:35:51 GMT

You can use the ApplyMap function (see help), something like this

MyMap:

mapping load * inline [From,To

'Nick','Chris'

];

Target:

LOAD BDM,

[Branch Name],

Applymap('MyMap',LBDM,LBDM) as LBDM,

TGT_YEAR,

FROM

QVD\TGT_YEAR.qvd

(qvd);

Re: replacing the name in a table

puttemans — Mon, 16 Mar 2015 13:37:16 GMT

Map_Name:

MAPPING LOAD * Inline

[Name, Newname

Nick, Chris];

Target:

LOAD BDM,

[Branch Name],

Applymap('Map_Name', LBDM) as LBDM,

TGT_YEAR,

FROM

QVD\TGT_YEAR.qvd

(qvd);

Re: replacing the name in a table

PrashantSangle — Mon, 16 Mar 2015 13:38:21 GMT

Hi,

If you want to replace only one name

then use if(wlidmatch(LBDM,'Nick'),'Chris',LBDM) as Ne_LBDM

else use ApplyName()

Regards