Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Comparing 2 tables without relation

Hello,

 

I have 2 tables as below :

vlan

entityvlan
CIL1064
CIL1069
CIL1070
CIL1072
CIL1075
CIL1076
CIL1078
CIL1080
CIL1082
CIL1100
CIL1101
CIL1104
CIL1107
CAT1108
CIL1108
CAT1109
CIL1109
CIL1111
CIL1112
CAT1113
CAT1114
CIL1114
CAT1115
CAT1116
CIL1116
CAT1117
CIL1117
CIL1118
CIL1120
CIL1121
CIL1122
CAT1123
CIL1123
CAT1124
CIL1124
CAT1125
CIL1125
CAT1127

 

Port

NameSectionVLANNumPorts
ALLVLAN 75CAG10641
ALLVLAN 820CAG10641
ALLVLAN 1565CAG10641
ALLVLAN 2310CAG10648
ALLVLAN 3051CAG10641
ALLVLAN 3790CAG10648
ALLVLAN 4506CAG10641
ALLVLAN 5251CAG10641
ALLVLAN 5996CAG10641
ALLVLAN 6741CAG10641
ALLVLAN 76CAG10698
ALLVLAN 821CAG10698
ALLVLAN 1566CAG10698
ALLVLAN 2311CAG10698
ALLVLAN 3052CAG10698
ALLVLAN 4507CAG10698
ALLVLAN 5252CAG10698
ALLVLAN 5997CAG10698
ALLVLAN 6742CAG10698
ALLVLAN 77CAG10701
ALLVLAN 822CAG10701
ALLVLAN 1567CAG10701
ALLVLAN 2312CAG10708
ALLVLAN 3053CAG10701
ALLVLAN 3791CAG10708
ALLVLAN 4508CAG10701
ALLVLAN 5253CAG10701
ALLVLAN 5998CAG10701
ALLVLAN 6743CAG10701
ALLVLAN 78CAG10721
ALLVLAN 823CAG10721
ALLVLAN 1568CAG10723
ALLVLAN 2313CAG10728
ALLVLAN 3054CAG10721
ALLVLAN 3792CAG10728
ALLVLAN 4509CAG10721

 

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.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.