Forum Discussion
Summerizing data over 2 tables
I have 2 tables. Table1 has a column StaffNum.
Table2 has columns CourseTitle & StaffNum
Is it possible to create a table where column 1 is all the StaffNums from Table1 and column 2 contains all the courses relating to that StaffNum. For example, the output could be
| StaffNum | CourseTitle |
| 123 | Course1 |
| 123 | Course2 |
| 123 | Course3 |
| 123 | Course4 |
| 234 | Course1 |
| 345 | Course2 |
| 345 | Course4 |
Hi dabutchart ,
Create the following data model, then refer to the corresponding fields in the table visual and filter the rows that are not empty in the fiter.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
dabutchart , isn't the table you want (with columns StaffNum and CourseTitle) the same as Table2 that you mention you have (which has columns CourseTitle and StaffNum)?
How is the table you want different to Table2?
The difference would be that the output table would contain all StaffNums from Table1 and the CourseTitles from Table2.
dabutchart , sorry but I cannot see the difference. Could you please post an example showing Table1, Table2, and the desired output table?
v-henryk-mstfCommunity Support
Hi dabutchart ,
Create the following data model, then refer to the corresponding fields in the table visual and filter the rows that are not empty in the fiter.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
