Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Bridge Table to bypass Many-to-Many Problem

Hello community, I am hoping you can help me.  I have one column in Table A with part numbers, all unique except for a string of 0's afterwards. Those zero's are there because in the source data t...
Need Help
Show and Tell
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

    1. Create a calculated table.

    Bridge Table =
DISTINCT (
    UNION ( VALUES ( 'Table A'[Part Numbers] ), VALUES ( 'Table B'[Part Numbers] ) )
)

     

    2. Create relationships.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ImkeF - Since both Table A and B contain duplicates... the bridge table would display all part numbers and the one 0 with no duplicates. 

 

That way Table A can have a relationship with Bridge table and, 

Table B can have a relationship with the Bridge Table. 

 

hi PaulDBrown I will try that, thanks!

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago
Anonymous
Before you append the new tables, make sure both columns have the same name (sorry, I forgot to mention that)