Forum Discussion
Using columns from different tables in a visual table
So what I did was manage the relationships so that the columns which where in both tables would have a relationship.
I'd say they are working properly, but I encountered another issue when trying to reach my end goal.
I wanted to somehow have a final results column somewhere on the page sort of like the one below (that one doesn't work though)Basically what I want to do is compare resultA, resultB, resultC, and resultD and if they are all "PASS" I want the resultFINAL column to output "PASS"
Hi there,
What you are trying to do can be done as long as your tables have the correct structure and relationship between them. What I see is that neither table has unique values, also in your table 1 you have A,B,C,D measurements as columns.
One approach is to create two tables, one for Positions and other one for Products. This is convenient if you are going to be adding more of those records in the future. You can then create relationship between your reference and Table 1 tables to these two tables.
A quick alternative is to create a calculated column concatenating Product&Position&Type of Measure in both tables, then you can create a relationship with these columns without creating more tables. But for this you should have Type of Measure as rows and not columns in your table 1
Let me know if it works
Alejandro