joining two values

[#1]

Hi

as i shown in the below image what i have highlighted in red is the same person who has two names in the DB i want to combine these two record as 1 n show the result how can i do this??

thank you in advance

[PrashantSangle]

Welcome.

Regards,

[#3]

thank you 4 your help to

[maxgro]

nested if

Temp:

load * inline

[

SDExecutives,Sale

Rohan Fernando,803

Dasun Wedaasinghe,285

Chathura Munasinghe,221

Chathura Munasingha,172

Chathura Munasingho,172

Diyath wickramaratne,128

Nuwan Shaweendra,103

Kaushal Jayabahu,93

Kaushal Premawansha,186

];

Main:

load

*,

if(WildMatch(SDExecutives, '*chathura*'), 'Chathura Munasinghe',

if(WildMatch(SDExecutives, '*kaushal*'), 'Kaushal Jayabahu',

if(WildMatch(SDExecutives, '*not?exists*'), 'not exists',

SDExecutives))) as SDExecutives_New

Resident Temp;

drop table Temp;

another one

Main:

load

*,

pick(  WildMatch(SDExecutives,   '*chathura*',   '*kaushal*',   '*'  ),

  'Chathura Munasinghe',  'Kaushal Jayabahu',  SDExecutives  ) as SDExecutives_New

Resident Temp;

drop table Temp;

from online help

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.