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]

Hi,

If SDExcuetvieAssigne is your dimension

then write in your deimension tab

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',SDExcuetiveAssigne)

Regards

[#3]

can i add more names to the same equation ?? in the image can u see there is a norther name as "kaushal" with two surnames i want to combine that to so is it possible to attach that to the same wild-match??

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

yes you can use multiple ifs.

Regards

ASHFAQ

[PrashantSangle]

Hi,

You can not implemented in same wildmatch but,

You can go with nested if else

like,

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne)

Regards,

[#7]

i am getting an error in this

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',wildmatch(SDExcuetiveAssigne,'Kaushal*'),  <-- (this is underlined in red)

'Kaushal',SDExcuetiveAssigne)

[PrashantSangle · Accepted solution]

Hi,

Write it in if Condition like

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',if(wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne))

Regards,

[#9]

a if was miss there Right??

[#10]

thank you soooo much it works perfectly