Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to find exact keyword in description field to do the categorization of tickets.
Example:
TICKET:
ID | Desc |
1 | Duplicate id call has been created |
2 | Technically Resolved |
3 | Disk Clean up to be done |
4 | My Laptop is(hostname):"HTTFFV" not rebooting |
KEY :
Key | Category |
Laptop | Laptop |
Clean | Disk |
Closed | Closed Call |
Duplicate | Duplicate |
Output:
ID | Desc | Category |
1 | Duplicate id call has been created | Duplicate |
2 | Call id :- 11 Technically closed | Calls |
3 | D drive Clean up to be done | Drive |
4 | My Laptop is(hostname):"HTTFFV" not rebooting | Laptop |
I tried with pick along with wildmatch but its not working as per expected output. Kindly supporting finding the exact keyword from field.
Something along the lines of:
Pick(WildMatch(Desc,'*Laptop*','*Clean*','*Closed*','*Duplicate*'),'Laptop','Disk','Closed Call','Duplicate') as Category
Hi,
Thanks for your response.
In my table, in the description i have two keyword string, in that case how the wildmatch will work.
Example, i have description like "Laptop.Disk Space Issue.Disk Space Issue" and i have a keyword as 'Laptop and disk also but i wanted to pick only disk as key in this scenario. So how the wildmatch will be applied here.
Wildmatch will stop at the first match, so the order you place your keywords in will determine which one gets picked.
Hi,
This is the sample i have shared but in actual scenario we have n number of keywords and with need to categorize the tickets which is based on ITSM tool. So in that case making it in order will not give us solution.
Please suggest if any other solution to find the keyword.
For a more robust solution, albeit a slower one, you could try the approach suggested here...