Forum Discussion

eltorr0's avatar
eltorr0
Regular Visitor
9 years ago

Difference between two matrix tables

Hi,   I'm trying to recreate an existing excel template that provides the difference between two tables.   I created two separate matrix tables, now i'm looking to create a third matrix table tha...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi eltorr0

 

Can you please put up a sample of the data you are working with?

 

You will require to have some type of common column between the different matrix tables, so that you know which values to subtract from each other.

eltorr0's avatar
eltorr0
Regular Visitor
9 years ago

Hi GilbertQ,

the rows and columns have the same name, see sample screenshot:

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi eltorr0

     

    What you could then do is in the Query Editor Merge the tables Matrix1 and Matrix 2 joining on the Ratio Column.

    • eltorr0's avatar
      eltorr0
      Regular Visitor
      9 years ago

      Each table has a two separate relationships for the Ratio and Distance, the values are stored on a common data table.  

      Any suggestion on getting it to work using this type of relationship?