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

Anonymous's avatar
Anonymous
Not applicable
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