Containsstring between 2 Tables

[furg42]

Hello,

i have the following situation:

Table A:

ID	Description	Category (measured row with DAX)
01	this is a audi car
02	yellow mercedes
03	an red apple

Table B:

Keywords	Category
audi	Car
mercedes	Car
apple	Fruit

Know I want to do the following: 

Read each data in Table A[Description] and look for certain strings and compare it with the values in Table B[Keywords]. 

If the description contains a word from Keywords, insert the value in Table B[Category] to Table A[Category]

Expected result:

Table A:

ID	Description	Category (measured row)
01	this is a audi car	Car
02	yellow mercedes	Car
03	an red apple	Fruit

Can someone help me?

Thanks!

Best

[danextian · Accepted solution]

Hi @furg42 ,

Have a look at the attached pbix. It doesn't necessarily address your use case but can help you get started.

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula in Table A works.

Hope this helps.

Category = FIRSTNONBLANK(FILTER(VALUES('Table B'[Keywords]),SEARCH('Table B'[Keywords],'Table A'[Description],1,0)),1)

[danextian · Accepted solution]

Hi @furg42 ,

Have a look at the attached pbix. It doesn't necessarily address your use case but can help you get started.