topic Re: Rename 2 values in field to something else in QlikView

Rename 2 values in field to something else

aaronnayan — Sat, 16 Nov 2024 19:42:33 GMT

Hi Guys,

Can anyone aid me in renaming 2 values within a field within the script?

Field = [Salesperson]

John
Mary
Sue
Frank
Barbara
Terry

I would like to change "Sue" to "Susan" and "John" to "Jonathon".

I have already tried if(Salesperson='Sue','Susan', AND if(Salesperson='John','Johnathon', Salesperson) as Salesperson

It doesnt work. The field Salesperson comes from a QVD with more than a 100 values.

I do alternatively have the SalespersonID field if something could be done from that?

Re: Rename 2 values in field to something else

Vegar — Fri, 08 Nov 2019 18:37:58 GMT

Try using ApplyMap()

MapPerson:

MAPPING Load * inline [

A , B

Sue, Susan

John, Johnaton

];

Data:

Load

Applymap ('MapPerson', Salesperson, Salesperson) as Salesperson,

Other fields

From Source;

Re: Rename 2 values in field to something else

aaronnayan — Fri, 08 Nov 2019 18:35:56 GMT

Hi That doesnt work. I get no values loaded in the field....

Re: Rename 2 values in field to something else

Vegar — Fri, 08 Nov 2019 18:38:45 GMT

Oops, my bad. It is supposed to be mapping load. I'll adjust my original answer.

Re: Rename 2 values in field to something else

Brett_Bleess — Wed, 13 Nov 2019 17:21:45 GMT

Aaron, did Vegar's adjust post get things working as you wished? If so, be sure to come back to the thread and use the Accept as Solution button on his main post to give him credit for the help and to let others know it did work. If you are still working upon things, leave an update.

Regards,
Brett

Re: Rename 2 values in field to something else

Marcos_rv — Wed, 13 Nov 2019 18:04:11 GMT

try this:
if(Salesperson='Sue', 'Susan' , if(Salesperson='John' , 'Johnathon', Salesperson) ) as Salesperson