A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Output - data combined whenever the ID is the same | Input - data with various entries for the same ID | |||||||
2 | ID | Data 1 | Data 2 | Data 3 | ID | Data 1 | Data 2 | Data 3 | |
3 | YY0231 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M | |||||||
4 | YY0231 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M, 1xCat6 2M, 10xLWL OD SM 2M, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 3xDTR 2468 B8, 1xDTR 2242 B1B3, 2xDTR 2242 B1B3, 3xDTR 2217 B20 | 18xHRDF 3m, 6xHRDF 5m | YY0231 | 1xCat6 2M, 10xLWL OD SM 2M, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 3xDTR 2468 B8, 1xDTR 2242 B1B3, 2xDTR 2242 B1B3, 3xDTR 2217 B20 | 18xHRDF 3m, 6xHRDF 5m | |||
5 | YY0311 | 1xCylinder, 1xOD 6340, 1xKey, 3xDTR holder (3), 1x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630 | |||||||
6 | YY0311 | 1xCylinder, 1xOD 6340, 1xKey, 3xDTR holder (3), 1x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 11xLWL SM 5M, 3xSXK Rail, 11xLWL OD SM 5M, 1xCB 30A, 8x7/16 Cap IP68, 8x4.3-10 Cap IP68, 1xSubframe, 1xPDU - 20DC, 2xDTR 2217 B7, 2xDTR 2242 B1B3, 2xDTR 2242 B1B3, 1xSingle Pole | 1xMF SM (12) 30M, 1xFO SM (24), 2xGND Kit, 2xPTTA, 1xFTTA SM (36), 1xMF SM (24) 30M, 1x12x6mm 30M, 1x12x6mm 30M | 12xHMDF 3m | YY0311 | 11xLWL SM 5M, 3xSXK Rail, 11xLWL OD SM 5M, 1xCB 30A, 8x7/16 Cap IP68, 8x4.3-10 Cap IP68, 1xSubframe, 1xPDU - 20DC, 2xDTR 2217 B7, 2xDTR 2242 B1B3, 2xDTR 2242 B1B3, 1xSingle Pole | 1xMF SM (12) 30M, 1xFO SM (24), 2xGND Kit, 2xPTTA, 1xFTTA SM (36), 1xMF SM (24) 30M, 1x12x6mm 30M, 1x12x6mm 30M | 12xHMDF 3m | |
7 | YY1224 | 2xDTR holder (3), 1xRack 200, 1x2x6mm 100M, 1xDPE 6630 | |||||||
8 | YY1224 | 2xDTR holder (3), 1xRack 200, 1x2x6mm 100M, 1xDPE 6630, 2xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B20 | 4xHRDF 5m, 8xHRDF 3m | YY1224 | 2xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B20 | 4xHRDF 5m, 8xHRDF 3m | |||
9 | YY1372 | 2xDTR 2468 B8, 1xPDU - 20DC, 4x4.3-10 Cap IP68, 1xCat6 5M, 4xLWL OD SM 2M, 2xDTR 2217 B20, 1xDPE 6630 | YY1372 | 1xDPE 6630 | |||||
10 | YY2554 | 1xRack 200, 3xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M | |||||||
11 | YY2554 | 1xRack 200, 3xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M, 3xLWL OD SM 2M, 1xCat6 10M, 2x4.3-10 Cap IP68, 1xPDU - 20DC, 1xDTR 2217 B20, 1xDTR 2242 B1B3, 1xDTR 2468 B8 | 2xHRDF 2m, 6xHRDF 3m | YY2554 | 3xLWL OD SM 2M, 1xCat6 10M, 2x4.3-10 Cap IP68, 1xPDU - 20DC, 1xDTR 2217 B20, 1xDTR 2242 B1B3, 1xDTR 2468 B8 | 2xHRDF 2m, 6xHRDF 3m | |||
12 | YY2766 | 1xDPE 6630, 1x2x6mm 100M, 1xDTR holder (3) | |||||||
13 | YY2766 | 1xDPE 6630, 1x2x6mm 100M, 1xDTR holder (3), 1xDTR 2217 B7, 1xDTR 2212 B8, 2xCB 30A, 1xCat6 2M, 2xLWL OD SM 2M | 4xHRDM 3m | YY2766 | 1xDTR 2217 B7, 1xDTR 2212 B8, 2xCB 30A, 1xCat6 2M, 2xLWL OD SM 2M | 4xHRDM 3m | |||
14 | YY2903 | 2x2x6mm 100M, 3xDTR holder (3), 1xDPE 6630, 1xDPE 6630 | |||||||
15 | YY2903 | 2x2x6mm 100M, 3xDTR holder (3), 1xDPE 6630, 1xDPE 6630, 3xDTR 2212 B8, 2xDTR 2217 B7, 3xDTR 4415 B3, 1xDTR 2217 B7, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 3M, 9xLWL OD MM 5M, 3xLWL OD MM 2M, 12xLWL MM 2M, 3xSXK Rail | 8xHMDF 5m, 8xHMDF 4m, 20xHMDF 2m | YY2903 | 3xDTR 2212 B8, 2xDTR 2217 B7, 3xDTR 4415 B3, 1xDTR 2217 B7, 6x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 3M, 9xLWL OD MM 5M, 3xLWL OD MM 2M, 12xLWL MM 2M, 3xSXK Rail | 8xHMDF 5m, 8xHMDF 4m, 20xHMDF 2m | |||
16 | YY4046 | 1xCylinder, 1xKey, 1xOD 6340, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 1x2x6mm 100M | |||||||
17 | YY4046 | 1xCylinder, 1xKey, 1xOD 6340, 1x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 1x2x6mm 100M, 2xDTR 2217 B20, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 2xCB 30A, 8xLWL OD SM 5M, 6xLWL OD SM 2M, 6xRET 1M, 4xSXK Rail, 4xDTR holder (2), 2xDTR 2468 B8, 2xDTR 2242 B1B3, 2xSingle Pole, 2xDTR 2242 B1B3 | 20xHMDF 4m, 8xHMHM 5m, 4xHMDF 5m, 4xHMHM 2m | YY4046 | 2xDTR 2217 B20, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 2xCB 30A, 8xLWL OD SM 5M, 6xLWL OD SM 2M, 6xRET 1M, 4xSXK Rail, 4xDTR holder (2), 2xDTR 2468 B8, 2xDTR 2242 B1B3, 2xSingle Pole, 2xDTR 2242 B1B3 | 20xHMDF 4m, 8xHMHM 5m, 4xHMDF 5m, 4xHMHM 2m | |||
18 | YY4497 | 1xOD 6340, 1xCylinder, 1xKey, 1xDPE 6630, 4xDTR holder (3), 2x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630 | |||||||
19 | YY4497 | 1xOD 6340, 1xCylinder, 1xKey, 1xDPE 6630, 4xDTR holder (3), 2x2x6mm 100M, 1x2x6mm 100M, 1xDPE 6630, 2xSingle Pole, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B7, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCB 30A, 12xLWL OD SM 10M, 9xLWL OD SM 5M, 4xSXK Rail | 6xHMDF 5m, 18xHMDF 3m | YY4497 | 2xSingle Pole, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B7, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCB 30A, 12xLWL OD SM 10M, 9xLWL OD SM 5M, 4xSXK Rail | 6xHMDF 5m, 18xHMDF 3m | |||
20 | XX5019 | 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1x2x6mm 100M | |||||||
21 | XX5019 | 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1x2x6mm 100M, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 3M, 4xLWL OD SM 2M, 2xDTR 2468 B8, 2xDTR 2217 B20 | XX5019 | 8x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 3M, 4xLWL OD SM 2M, 2xDTR 2468 B8, 2xDTR 2217 B20 | |||||
22 | XX5283 | 4xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630 | |||||||
23 | XX5283 | 4xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 2xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 10M, 21xLWL OD SM 2M, 21xLWL SM 5M, 2xRET 10M, 2xRET 5M, 2xRET 3M, 3xRET 2M, 4xSXK Rail, 1xDTR 2468 B8, 3xDTR 2217 B20 | 2xGND Kit, 2xPTTA, 2xFO SM (24), 2xFTTA SM (36), 2xMF SM (24) 50M, 1xMF SM (12) 50M, 1x12x6mm 50M, 1x12x6mm 50M | 16xHMHM 2m, 10xHMDM 2m, 8xHMDM 6m, 2xHMDM 3m, 2xHMHM 3m, 8xHMDM 5m | XX5283 | 2xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 8x4.3-10 Cap IP68, 1xPDU - 20DC, 2xCat6 10M, 21xLWL OD SM 2M, 21xLWL SM 5M, 2xRET 10M, 2xRET 5M, 2xRET 3M, 3xRET 2M, 4xSXK Rail, 1xDTR 2468 B8, 3xDTR 2217 B20 | 2xGND Kit, 2xPTTA, 2xFO SM (24), 2xFTTA SM (36), 2xMF SM (24) 50M, 1xMF SM (12) 50M, 1x12x6mm 50M, 1x12x6mm 50M | 16xHMHM 2m, 10xHMDM 2m, 8xHMDM 6m, 2xHMDM 3m, 2xHMHM 3m, 8xHMDM 5m | |
24 | XX5287 | 1xPadlock, 1xKey, 1xDPE 6630, 2x2x6mm 100M, 1x2x6mm 100M | |||||||
25 | XX5287 | 1xPadlock, 1xKey, 1xDPE 6630, 2x2x6mm 100M, 1x2x6mm 100M, 18xLWL SM 10M, 18xLWL OD SM 5M, 1xPDU - 20DC, 2xCB 30A, 6x4.3-10 Cap IP68, 3xRET 10M, 6xRET 5M, 3xSXK Rail, 3xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3 | 1xMF SM (12) 50M, 2xMF SM (24) 50M, 2xFO SM (24), 1xPTTA, 3xGND Kit, 2xFTTA SM (36), 2xPTTA, 1x12x6mm 50M, 1x12x6mm 50M, 1x12x6mm 50M | 18xHMDM 4m, 16xHMDM 6m, 2xHMDM 7m | XX5287 | 18xLWL SM 10M, 18xLWL OD SM 5M, 1xPDU - 20DC, 2xCB 30A, 6x4.3-10 Cap IP68, 3xRET 10M, 6xRET 5M, 3xSXK Rail, 3xDTR 2468 B8, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3 | 1xMF SM (12) 50M, 2xMF SM (24) 50M, 2xFO SM (24), 1xPTTA, 3xGND Kit, 2xFTTA SM (36), 2xPTTA, 1x12x6mm 50M, 1x12x6mm 50M, 1x12x6mm 50M | 18xHMDM 4m, 16xHMDM 6m, 2xHMDM 7m | |
26 | XX5750 | 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M | |||||||
27 | XX5750 | 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDTR holder (3), 1xDPE 6630, 1x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 1xPDU - 20DC, 1xCat6 10M, 1xLWL OD SM 10M, 6xLWL OD SM 2M, 1xDTR 2212 B8 | 14xHRDF 3m | XX5750 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 1xPDU - 20DC, 1xCat6 10M, 1xLWL OD SM 10M, 6xLWL OD SM 2M, 1xDTR 2212 B8 | 14xHRDF 3m | |||
28 | XX5751 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M | |||||||
29 | XX5751 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 6xLWL OD SM 2M, 3xLWL OD SM 10M, 1xCat6 10M, 6xRET 1M, 1xPDU - 20DC | 6xHRDF 2m, 6xHRDF 3m | XX5751 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 6xLWL OD SM 2M, 3xLWL OD SM 10M, 1xCat6 10M, 6xRET 1M, 1xPDU - 20DC | 6xHRDF 2m, 6xHRDF 3m | |||
30 | XX7080 | 1xDTR holder (3), 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M | |||||||
31 | XX7080 | 1xDTR holder (3), 1xRack 200, 2xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 6xLWL OD SM 10M, 12xLWL OD SM 2M, 3xRET 1M | 12xHRDF 3m, 6xHRDM 3m | XX7080 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 6xLWL OD SM 10M, 12xLWL OD SM 2M, 3xRET 1M | 12xHRDF 3m, 6xHRDM 3m | |||
32 | XX7405 | 2xDTR holder (3), 1xRack 200, 2x2x6mm 100M, 1xDTR holder (3), 1xDPE 6630 | |||||||
33 | 2xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M | 12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7m | XX7405 | 12x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 3xLWL OD SM 10M, 3xLWL OD SM 5M, 3xLWL OD SM 2M, 6xLWL SM 2M, 2xRET 10M, 4xRET 5M, 2xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2468 B8 | 2xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M | 12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7m | |||
34 | XX7405 | 12x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 3xLWL OD SM 10M, 3xLWL OD SM 5M, 3xLWL OD SM 2M, 6xLWL SM 2M, 2xRET 10M, 4xRET 5M, 2xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2468 B8, | 2xGND Kit, 2xPTTA, 1xFO SM (24), 1xFTTA SM (36), 1xMF SM (12) 60M, 1x12x6mm 60M, 1x12x6mm 60M1xMF SM (24) 60M | 12xHRDF 3m, 2xHMDM 4m, 6xHMDM 5m, 4xHMDM 7m | XX7405 | 1xMF SM (24) 60M | |||
35 | XX7559 | 1xDPE 6630, 3xDTR holder (3), 2x2x6mm 100M | |||||||
36 | XX7559 | 1xDPE 6630, 3xDTR holder (3), 2x2x6mm 100M, 12x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 6xLWL OD MM 5M, 3xLWL OD MM 2M, 9xLWL MM 2M, 6xRET 5M, 3xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2468 B8 | 1xGND Kit, 1xPTTA, 1xFO MM (24), 1xFTTA MM (36), 1xMF MM (24) 50M, 1x12x6mm 50M | 8xHMDM 7m, 12xHMDF 2m, 4xHMDM 8m | XX7559 | 12x4.3-10 Cap IP68, 1xPDU - 20DC, 1xCat6 2M, 6xLWL OD MM 5M, 3xLWL OD MM 2M, 9xLWL MM 2M, 6xRET 5M, 3xSXK Rail, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2468 B8 | 1xGND Kit, 1xPTTA, 1xFO MM (24), 1xFTTA MM (36), 1xMF MM (24) 50M, 1x12x6mm 50M | 8xHMDM 7m, 12xHMDF 2m, 4xHMDM 8m | |
37 | XX7565 | 3xDTR holder (3), 1xRack 200, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630 | |||||||
38 | XX7565 | 3xDTR holder (3), 1xRack 200, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 12xLWL OD SM 5M, 9xLWL OD SM 2M, 6xRET 1M | 18xHRDF 2m | XX7565 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 3xDTR 2217 B20, 3xDTR 2212 B8, 1xPDU - 20DC, 2xCat6 3M, 12xLWL OD SM 5M, 9xLWL OD SM 2M, 6xRET 1M | 18xHRDF 2m | |||
39 | XX7576 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M | |||||||
40 | XX7576 | 3xDTR holder (3), 1xRack 200, 1xDPE 6630, 1xDPE 6630, 2x2x6mm 100M, 3xDTR 2217 B20, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 9xRET 1M, 6xLWL OD SM 2M, 15xLWL OD SM 10M, 2xCat6 10M, 1xPDU - 20DC, 8x4.3-10 Cap IP68, 3xDTR 2468 B8 | 24xHRDF 2m | XX7576 | 3xDTR 2217 B20, 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 9xRET 1M, 6xLWL OD SM 2M, 15xLWL OD SM 10M, 2xCat6 10M, 1xPDU - 20DC, 8x4.3-10 Cap IP68, 3xDTR 2468 B8 | 24xHRDF 2m | |||
41 | 12xHRDF 3m, 12xHRDF 5m | XX7735 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 12xLWL OD SM 10M, 6xLWL OD SM 5M, 6xRET 1M, 2xCat6 3M, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 3xDTR 2468 B8 | 12xHRDF 3m, 12xHRDF 5m | |||||
42 | XX7735 | 3xDTR 2242 B1B3, 3xDTR 2242 B1B3, 12xLWL OD SM 10M, 6xLWL OD SM 5M, 6xRET 1M, 2xCat6 3M, 1xPDU - 20DC, 6x4.3-10 Cap IP68, 3xDTR 2468 B8, 1xRack 150, 2xDTR holder (3), 1xRack 150, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630 | 12xHRDF 3m, 12xHRDF 5m | XX7735 | 1xRack 150, 2xDTR holder (3), 1xRack 150, 1xDTR holder (3), 2x2x6mm 100M, 1xDPE 6630, 1xDPE 6630 | ||||
43 | |||||||||
44 | |||||||||
45 | |||||||||
46 | |||||||||
47 | |||||||||
48 | |||||||||
49 | |||||||||
50 | |||||||||
51 | |||||||||
52 | |||||||||
53 | |||||||||
54 | |||||||||
55 | |||||||||
56 | |||||||||
57 | |||||||||
58 | |||||||||
59 | |||||||||
60 | |||||||||
61 | |||||||||
62 | |||||||||
63 | |||||||||
64 | |||||||||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 |