Compare two fields with Text contains

Question

I have two tables (table1 and table2). I want to perform an inner merge query with both tables.

I want to check if the parttial name field in table1 is found in table2 may be by using Text.Contains. I am not quite familiar with this.

Any help please please please.

Answer 1

To test if table1.Name is contained within a row of table2.Lookup Value:

in table1, add column ... custom column ... with formula:

= List.AnyTrue(let a=[Name] in List.Transform(Table2[Lookup Value], each Text.Contains(_,a)))