Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Write it in if Condition like
if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',if(wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne))
Regards,
Hi,
If SDExcuetvieAssigne is your dimension
then write in your deimension tab
if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',SDExcuetiveAssigne)
Regards
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??
Hi,
may be like this.
Regards
ASHFAQ
Hi,
yes you can use multiple ifs.
Regards
ASHFAQ
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,
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)
Hi,
Write it in if Condition like
if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',if(wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne))
Regards,
a if was miss there Right??
thank you soooo much it works perfectly