How to check if a column contains the characters in the column of another table

Like (0) Share

Report

Posted on 28 Nov 2023 05:50:41 by Community Power Pla...

Hi,

I have 2 tables below. I need to have a new column in Table1 to have a Boolean value if the Text contains any value listed in Table2 column "SearchText". I have tried to use list.ContainsAny() , but there is no space in the text so I can't use split to generate a text list. Is there any idea to achieve it? Thank!

Table1

ID	Name
1	coffeeprod
2	ABCcigarette
3	XXalcoholXX
4	ddbeverages

Table2

SearchText

coffee

cigarette

alcohol

All responses (2)

Answers (0)

Community Power Pla... on 28 Nov 2023 at 08:19:18

Like (0)

Report

Re: How to check if a column contains the characters in the column of another table

Thanks! it works for me.
v-mengmli-msft on 28 Nov 2023 at 06:10:36

Like (0)

Report
Re: How to check if a column contains the characters in the column of another table

Hi @Anonymous ,

I assume that if value in Name column returns "true", otherwise, returns "false".
Please try this:
AddColumns(Table1,"test",!IsBlank(LookUp(ForAll(Table2.SearchText As C,C.SearchText in Name),Value=true)))

Best regards,
Rimmon