Forum Discussion
Filter/Group Multiple Columns From Different Tables
I'm trying to show avg length, width and thickness by the item being face or a back in the matrix below. My problem is the length, width, and thickness values come from 3 different tables. Each of these tables has it's own Face/Back column that tells if the measurement is for a face or a back.
You can see that because of this I have 3 face/back columns in the matrix. I'd like to make this into 1 column. I tried to do this by making a face/back table and linking it with a one to many relationship but it only lets me do that to one table at a time. Is there any way to merge/group these three columns?
Thanks!
Add a column to each table that defines what dimension it is (Length/Width/Thickness) and rename the (mm) column to a standard one across all 3 tables so that you can append them into a single table that looks more like this:
This will make building visuals significantly easier.
3 Replies
Add a column to each table that defines what dimension it is (Length/Width/Thickness) and rename the (mm) column to a standard one across all 3 tables so that you can append them into a single table that looks more like this:
This will make building visuals significantly easier.
Yeah that makes this way simpler. Thanks!
Here's an example of what each table looks like. This is the length table.
