how to get keywords bundled

[Rob_Reg_777]

Hi,

I have the following tables:

Table 1:

Table 2:

I need to match the keyword within the short_description column and as a result the group respectively. I have used filter & containstring but when I have two keywords it chooses the wrong one. Like in this example for "access failure" it gave me failure instead of access issues. How can I fix this?

Thanks

[Ashish_Mathur]

Hi,

If 2 or more keywords are found in the Short description text, then what result are you expecting and why? 

[Rob_Reg_777]

Hi Ashish,

In this case will be the first from left to right in the short description since the second (or more) could be just to complete a phrase like in the example "access failure" access must be the main keyword instead of failure.

Thanks!

[Ashish_Mathur]

Hi,

Write these calculated column formulas in the Description table.  Ensure that in the keywords table, the specific words are at the top and generic ones (such as "failure") are at the bottom

keyword = FIRSTNONBLANK(FILTER(VALUES(keywords[keyword]),SEARCH(keywords[keyword],'Description'[short_description],1,0)),1)

Group = LOOKUPVALUE(keywords[Group],keywords[keyword],'Description'[keyword])

Hope this helps.