i'm trying to recreate a parser, inside different applications (just to find out a good and light way to do it) that, with a list of given values try to classify a row. Here it is an example:
Table1: contains items that have to be classified:
| Code | Description |
|---|---|
| 1 | this is a common row that belong to Jake |
| 2 | this is a special row that belong to Thomas |
Table 2: contains Keywords that have to be searched inside Table1 [Description]
| Keywords | Category |
|---|---|
| common, Jake | Common Jake Row |
| special, belong, row, Thomas | Special Thomas Row |
The result that i want to obtain is:
| Code | Description | Category |
|---|---|---|
| 1 | this is a common row that belong to Jake | Common Jake Row |
| 2 | this is a special row that belong to Thomas | Special Thoams Row |
Is there a way to have this in VBA or Excel or PowerBI?
Thanks in advance