Forum Discussion
Slicer to filter on different tables for same value
Hi Anonymous
In order to link the two tables, you need to create a "sites table" as a bridge.
You can do it by following these steps :
IN PQ
1. Create refernce table of one of yours2. Append tjis new table to the second
3. Remove all columns except "site"
4. Remove duplicates
5. After Close and Apply on model view,
Fix the type of relationships in the tables created automatically.
Both should be "one to many" with a single directionResult:
Connected tables , which you can combine , slice and diceLink to Sample File
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHi Anonymous
In order to link the two tables, you need to create a "sites table" as a bridge.
You can do it by following these steps :
IN PQ
1. Create refernce table of one of yours
2. Append tjis new table to the second
3. Remove all columns except "site"
4. Remove duplicates
5. After Close and Apply on model view,
Fix the type of relationships in the tables created automatically.
Both should be "one to many" with a single direction
Result:
Connected tables , which you can combine , slice and dice
Link to Sample File
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ritaf1983 Thanks a lot for your help. I didnt do it exactly the way you suggested but I worked on the connections. Thanks
Fanis