Hi
I have three table
table1
|
Name
|
| sam;sam@;sam@1;sam@2 |
| ant;ant@;ant@1 |
| jan;jan@ |
| george |
| susi |
| robert |
| josh |
| bob;bob@;bob@1 |
| cat;cat@;cat@1 |
Table2
|
Name1
|
| sam |
| ant |
| jan |
| hesi |
| yesu |
| paul |
| josh |
Table3
|
Name2
|
| sam |
| ant |
| jan |
| george |
| chema |
| robert |
| soba |
I want output like below because only sam, ant, jan only present in three tables, remaining all are not present in three tables, some are missed in even one table also.
I want matched and nonmatched values come as like below ouput tables only
| Nonmatched |
| hesi |
| yesu |
| paul |
| josh |
| george |
| chema |
| robert |
| soba |
| josh |
| bob;bob@;bob@1 |
| cat;cat@;cat@1 |
I want count on KPI as like below
