Forum Discussion

Helper I

3 years ago

Solved

Mapping columns from different tables where one has multiple delimited values

I have two tables that I would like to map together, either using a join or relationship or a lookup (not sure which is most appropriate). In Table 1 I have a column that lists English words/slang an...

tamerj1

3 years ago

Hi user180618
Please try

Matched =
MAXX (
    FILTER (
        VALUES ( Table2[US_english] ),
        CONTAINSSTRING ( Table1[Word], Table2[US_english] )
    ),
    Table2[US_english]
)

The MAXX shall not be required and can be removed