Forum Discussion
Performing a join using "contains"
I have two tables and Table "A" has a list of error messages while Table "B" has a list of keywords. Is there any way to return a list of those error messages from Table A that a contain a keyword ...
GaryBushey I have it working but not sure if it is the best way to do it. First, I add a dummy column to each table that contains the same value, then I do a full outer join on the two tables using those new columns. Since I just need to get a count of the matching items I can do
summarize countif(TableBcolumn contains TableAcolumn) by TableAcolumn