Return value that match a list of specific list of keywords

[Tim01425]

I have two tables - example:

 and

I'm looking to add a 2 columns in table1 for matching existing keyworkds (case insensitive) and code from Table2.

The expected results should look like this:

 

Is this something that can be done?

Thank you

[ThxAlot]

let
    Table1 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCshJzFMwVYrViVZyTE5OLS5WKMlXSMtMzUkpBgtWgAGYWQBSmpZfpABRCBYzLkpRKEvNS8kvAnNDihIz8zLz0hVyE/NKE3OAamIB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [FileName = _t]),
    Table2 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCshJzFPSUXI0MDBUitWJVgopSszMy8xLB4o5GRgYgcUck5NTi4uBIs4GBpZgkbDUvJT8IqBIpIGBqVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Keywords = _t, Code = _t]),


    KWs = Table.ToRows(Table2),
    #"Added Column" = Table.AddColumn(
            Table1,
            "col",
            each Table.FromColumns(List.Transform(List.Zip(List.Accumulate(KWs, {}, (s,c) => if Text.Contains([FileName], c{0}, Comparer.OrdinalIgnoreCase) then s & {c} else s)), each {Text.Combine(_, ",")}))
    ),
    #"Expanded col" = Table.ExpandTableColumn(#"Added Column", "col", {"Column1", "Column2"}, {"Keywords", "Code"})

in
    #"Expanded col"