Forum Discussion
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 Colu...
*:* 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.
*:* 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.
Thanks I ended up creating a merge into another table which is easier to work with.