Forum Discussion
Search and match String
Hello,
I need help with creating a Matrix of matching activity.
Got 2 tables -
Tab1 BaseActivity: That has List of All Activities
Tab2 Resource Activity: List of Resource and Activity they assoiate to (please note they are seperated by ',')
| BaseActivity |
| A |
| B |
| C |
| Resource Name | Activity |
| Tom | A,C |
| Mary | A,B,C |
| Ani | C |
The ultimate Matrix should show a match something like;
| Resource/ Activity ->/ | A | B | C |
| Tom | Yes | No | Yes |
| Mary | Yes | Yes | Yes |
| Ani | No | No | Yes |
Thanks in advance !
1 Reply
Hi,
First you should split activity column by delimiter (, is the delimiter) and then unpivot all the results (exept Resource Name):
