Find /compare text string segment between two tables

Thanks technosmith  🙂

I have attached a small PBIX with one approach.

Here is an extract of code for Table 1 with the Code column added:

let
    // ... Earlier steps here
    // Next step finds first matching Code from Table 2
    #"Added Code" = Table.AddColumn(#"Changed Type", "Code", each let CurrentCodeGroup = [CodeGroup] in List.First(List.Select(#"Table 2"[Code],each Text.Contains(CurrentCodeGroup,_))), type text)
in
    #"Added Code"

The Added Code step finds the first Code from Table 2 that is contained in the CodeGroup string.

A null value should be returned in the case of no match.

Regards