I would like to join the following tables in various combinations.   I want to Join some columns from Table 1 (PTP) with the utilization rates from Table 2, 3, and 4.

Tables:

1. PTP Interfaces
2. Detailed Interface
3. Interface RX
4. Interface TX

I can easily join Tables 2, 3, and 4 as several columns match.  The best column would be the “Name” or IDX columns

This issue is the PTP interfaces does not have any columns that can be easily used in a join without some detailed regex.

I think the solution would be to modify the connector so that the PTP Index uses the same port name convention as the Detailed interfaces.

The difference between these tables is that the 3 Detailed Interface tables are polled using SNMP while the PTP Interface table and the PTP Foreign Master Records is polled using NX-API.  I wonder if Cisco is using a different naming convention.

Is it possible to modified the connector to support a cohesive port naming convention for the PTP tables?