Forum Discussion

user180618's avatar
user180618
Icon for Helper I rankHelper 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's avatar
    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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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

ACS_BIM's avatar
ACS_BIM
Regular Visitor
1 year ago

I tried this and this is the error I received:

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    1 year ago

    ACS_BIM 

    this formula is to be used to create a calculated column. To use it in a query you need to use ADDCOLUMNS