Forum Discussion

apmulhearn's avatar
apmulhearn
Icon for Helper III rankHelper III
4 years ago
Solved

Lookup Multiple Values from Another Table & Concatenate with ; as delimeter

Hello,   I am working with two distinct tables which contain information about trips. I need Table2.AllEmailAddresses to contain all distinct matches from Table1.EmailAddress where the Status is Bo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi apmulhearn ,

    You can create a calculated column as below in Table2 to get it:

    Column = 
CONCATENATEX (
    FILTER (
        'Table1',
        'Table1'[DepartureID] = 'Table2'[Departurel]
            && 'Table1'[Status] = "Booked"
    ),
    'Table1'[EmailAddress],
    ";",
    'Table1'[EmailAddress],
    ASC
)

    By the way, why the email address “[email protected]” not be listed under the Departurel as "LGA:356985895"?

    Best Regards

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

apmulhearn could you please clarify further what you are looking for? Not sure what the ask is.

  • apmulhearn's avatar
    apmulhearn
    Icon for Helper III rankHelper III
    4 years ago

    Sure, I can try again.

    Basically, I need to be able to lookup values in table 1 and have them populate a column in table 2. However, there will often be more than 1 match on table 1. I need all matching values from table 1 to populate in the column in table 2, separated by a semicolon.