Forum Discussion

PCarson00's avatar
PCarson00
Frequent Visitor
2 years ago
Solved

Comparing columns from two different tables

I have a single visual table but its sourced from two seperate excel sheets.

 

The visual table needs to be filtered down, maybe a button that I can press to compare column A with column B and Column C with column D

 

B and D are from the other excel sheet

 

I have a many to many relationship already set for these tables.

 

I cant seem to create a measure or extra column that will do this comparison. Does it have something to do with the relationship?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    *:* relationships are not always the greatest. You could create a summary table of the unique keys from both tables and then create a relationship between those 3 tables (i.e. Summary table -> T1, Summary Table -> T2). 

     

    But without more details on what you're trying to accomplish or a sample data set, it's hard to help you further.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    *:* relationships are not always the greatest. You could create a summary table of the unique keys from both tables and then create a relationship between those 3 tables (i.e. Summary table -> T1, Summary Table -> T2). 

     

    But without more details on what you're trying to accomplish or a sample data set, it's hard to help you further.

    • PCarson00's avatar
      PCarson00
      Frequent Visitor
      2 years ago

      Thanks I ended up creating a merge into another table which is easier to work with.