Forum Discussion
Show only matching values from multiple tables
Hi Zilver ,
You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.
Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserWhat is the logic to achieve this table
Table 3
| Ord_Number | Status |
| 10 | D |
| 20 | D |
| 50 | U |
I do have the same problem. In my specific case I use names instead of numbers. Imagine data since 2019 from my team. In all this team some people left the team. I have a table with EVERYONE since 2019 and another with only the ones that are in the team right now. I want to use my second table to filter he first one so only the values of the second will appear.
So in resume. The first table as thousand of rows and columns. And the second one only has the names that I wat to "filter".
| Names | Age | ID | etc | etc | etc |
| Mike | 74 | 1325 | etc | etc | etc |
| Freddy | 26 | 1326 | etc | etc | etc |
| Carl | 99 | 7653 | etc | etc | etc |
| Mark | 34 | 1746 | etc | etc | etc |
| John | 57 | 9816 | etc | etc | etc |
| Mary | 86 | 2749 | etc | etc | etc |
Amitchandak | 30 | 5472 | etc | etc | etc |
| Names |
John |
| Mary |
| Mark |
| Amitchandak |
My final result should look like this
| Name | Age | ID | etc | etc | etc |
| Mary | 86 | 2749 | etc | etc | etc |
| Mark | 34 | 1746 | etc | etc | etc |
| Amitchandak | 30 | 5472 | etc | etc | etc |
| John | 57 | 9816 | etc | etc | etc |
Also , this should be displayed in a bar chart
Hope it helps