Rename 2 values in field to something else

[aaronnayan]

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?

[Vegar]

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;

[aaronnayan]

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

[Vegar]

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

[Brett_Bleess]

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

[Marcos_rv]

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