Network topology

[Zhanali1]

Hi everyone!
Maybe someone faced such a problem:

I want to build a Layer 2 network topology, I have enough data for this. I am working with the Network Diagram Viz app. And I have a table of links, something like this:

from	to	local_int	remote_int	linkcolor	type	linktext	value
AIC-switch-2960.aic.kz	SW9300test.aic.kz	Gi0/1	Gi1/0/23	green	deployment-server	Gi0/1 to Gi1/0/23	AIC-switch-2960.aic.kz
SW9300test.aic.kz	AIC-switch-2960.aic.kz	Gi1/0/23	Gi0/1	green	deployment-server	Gi1/0/23 to Gi0/1	SW9300test.aic.kz
SW9300test.aic.kz	SW3850test.aic.kz	Gi1/0/9	Gi1/0/9	green	deployment-server	Gi1/0/9 to Gi1/0/9	SW9300test.aic.kz
SW9300test.aic.kz	SW3850test.aic.kz	Gi1/0/10	Gi1/0/10	green	deployment-server	Gi1/0/10 to Gi1/0/10	SW9300test.aic.kz
SW3850test.aic.kz	SW9300test.aic.kz	Gi1/0/9	Gi1/0/9	green	deployment-server	Gi1/0/9 to Gi1/0/9	SW3850test.aic.kz
SW3850test.aic.kz	SW9300test.aic.kz	Gi1/0/10	Gi1/0/10	green	deployment-server	Gi1/0/10 to Gi1/0/10	SW3850test.aic.kz
AIC-switch-2960.aic.kz	SIP-W60B	Gi0/12	WAN PORT	green	phone-square	Gi0/12 to WAN PORT	AIC-switch-2960.aic.kz

And, accordingly, in the topology, this is:

Zhanali1_1-1627294670617.png

I took information about connected devices from AIC-switch-2960.aic.kz, SW9300test.aic.kz and SW3850test.aic.kz.

I just need to remove non-redundant links from the table. What solution can you advise to delete such entries automatically or some other way?

Thanks!

[kamlesh_vaghela]

@Zhanali1 

Can you please share your expected output from your provided sample ?

KV