Check contents in 2 tables (With contains condition) and return results

[brandonchan]

Hello,

I have 2 tables and would like to check if the content in Table 1.Column A is contained in Table 2.Column A. And finally would like to return other column's content in Table B by matching all valid results.

Table 1

Column A 

peter

michael

daniel

Table 2

Column A    Column B   Column C

peter c         A Grade      80

peter            B Grade      70

michael k     B Grade      65

Expected Results in Table 1

Table 1

Column A     Column B     Column C

peter             A Grade       80

peter             B Grade       70

michael         B Grade       65

daniel           

Great thanks

[Anonymous · Accepted solution]

Hi @brandonchan ,

Do you have c and k in the data source itself?

If not, use the Merge function directly, as follows.

If yes, please check fuzzy matching in Merge and set similarity threshold to 0.1.

Reference: Create a fuzzy match (Power Query)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

    you can use left outer join.

Thanks,

Shanthakumar.

[Anonymous]

You don't even have to use any of the optional parameters in this case. In the formula bar, type:

=Table.FuzzyJoin(Table1, {"Column A"}, Table2, {"Column A"}, JoinKind.LeftOuter)

--Nate

[Anonymous]

I would type = Table.FuzzyJoin in the formula bar, this is the best use case for it!

--Nate

[brandonchan]

Hi Nate

Thanks for your reply. I go through the doc about Table.FuzzyJoin but not really get the concept how it works in my case.

I would like to check Column A in both table and see if content in Table 1.Column A is contained in Table 2.Column A. And what would be the joinkind if I use Table.FuzzyJoin? Appreciate if you could explain further

Great thanks