Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cardinality/Relationship issue across multiple tables

I have Part Numbers in four tables.  Each table has the potential to have unique part numbers in it.  I want to be able to have a page wide filter that seaches all four tables and displays results in...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    If it were me, I would maybe create a new table that has all of the unique codes from all of my tables and then link that to each table one-way perhaps?

     

    Something like:

     

    Table = 
  DISTINCT(
    UNION(
      SELECTCOLUMNS('Table1',"__Part Number",[Part Number]),
      SELECTCOLUMNS('Table2',"__Part Number",[Part Number]),
      SELECTCOLUMNS('Table3',"__Part Number",[Part Number]),
      SELECTCOLUMNS('Table4',"__Part Number",[Part Number])
    )
  )
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

These tables do not seem like a master tables. Bring or create a part table and join all four tables with that.

Try to avoid manat to many and bi-directional join unless needed by use case.