Comparing 2 tables without relation

[Anonymous]

Hello,

I have 2 tables as below :

vlan

entity	vlan
CIL	1064
CIL	1069
CIL	1070
CIL	1072
CIL	1075
CIL	1076
CIL	1078
CIL	1080
CIL	1082
CIL	1100
CIL	1101
CIL	1104
CIL	1107
CAT	1108
CIL	1108
CAT	1109
CIL	1109
CIL	1111
CIL	1112
CAT	1113
CAT	1114
CIL	1114
CAT	1115
CAT	1116
CIL	1116
CAT	1117
CIL	1117
CIL	1118
CIL	1120
CIL	1121
CIL	1122
CAT	1123
CIL	1123
CAT	1124
CIL	1124
CAT	1125
CIL	1125
CAT	1127

Port

Name	Section	VLAN	NumPorts
ALLVLAN 75	CAG	1064	1
ALLVLAN 820	CAG	1064	1
ALLVLAN 1565	CAG	1064	1
ALLVLAN 2310	CAG	1064	8
ALLVLAN 3051	CAG	1064	1
ALLVLAN 3790	CAG	1064	8
ALLVLAN 4506	CAG	1064	1
ALLVLAN 5251	CAG	1064	1
ALLVLAN 5996	CAG	1064	1
ALLVLAN 6741	CAG	1064	1
ALLVLAN 76	CAG	1069	8
ALLVLAN 821	CAG	1069	8
ALLVLAN 1566	CAG	1069	8
ALLVLAN 2311	CAG	1069	8
ALLVLAN 3052	CAG	1069	8
ALLVLAN 4507	CAG	1069	8
ALLVLAN 5252	CAG	1069	8
ALLVLAN 5997	CAG	1069	8
ALLVLAN 6742	CAG	1069	8
ALLVLAN 77	CAG	1070	1
ALLVLAN 822	CAG	1070	1
ALLVLAN 1567	CAG	1070	1
ALLVLAN 2312	CAG	1070	8
ALLVLAN 3053	CAG	1070	1
ALLVLAN 3791	CAG	1070	8
ALLVLAN 4508	CAG	1070	1
ALLVLAN 5253	CAG	1070	1
ALLVLAN 5998	CAG	1070	1
ALLVLAN 6743	CAG	1070	1
ALLVLAN 78	CAG	1072	1
ALLVLAN 823	CAG	1072	1
ALLVLAN 1568	CAG	1072	3
ALLVLAN 2313	CAG	1072	8
ALLVLAN 3054	CAG	1072	1
ALLVLAN 3792	CAG	1072	8
ALLVLAN 4509	CAG	1072	1

I have 2 views belows :

I would like to count/ extract the port names which have the different number of VLAN between 2 tables.

Example : VLAN 1928 has 2 ports in table vlan but has 8 in table Port.

Thank you in advance for your help.

[Anonymous]

Hi @Anonymous ,

I think you can try code as below.

Measure = 
VAR _SELECTVLAN = VALUES(vlan[vlan])
RETURN
IF(MAX(Port[VLAN]) IN _SELECTVLAN, SUM(Port[NumPorts]),BLANK())

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.