Search and match String

[Anonymous]

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 !

[baghdadi62]

Hi,

First you should split activity column by delimiter (, is the delimiter) and then unpivot all the results (exept Resource Name):