Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Matched |
sam |
ant |
jan |
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
Count of matched |
3 |
Count of Nonmatched |
11 |
what are the field names?
how are these tables associated?
@MarcoWedel
please take filed names
for table1 filed name is name
for table2 field name is name1
for table3 field name is name2