Maybe this approach works?
if contains(upper([Comment]),"K9K_MOBILITY") then "K9K_MOBILITY"
elseif contains(upper([Comment]),"K9K_WARRANTY") then "K9K_WARRANTY"
elseif contains(upper([Comment]),"K9K_COST") then "K9K_COST"
elseif contains(upper([Comment]),"K9K_DD") then "K9K_DD"
You can add other category like "PIPE" with analyzing comments in detail.
K9K_9.0.twbx 36.6 KB
Thanx a lot for your valuable reply it is perfectly working
Happy to hear so.
BTW, could you mark the answer correct for other people to understand it's answered.
Thanks a lot for your contribution for my queries
actually i am new to tableau i am trying to enhancing my skills in tableau
but i know all the basics how to create the charts and dashboards and also analysis part
but when it will come to write a functions i am not getting proper examples can you please tell me the proper guide for this or else any documents if you have try to share with me it would be great help full to my career