Chip Resistor Duplicate Part Number: 414 of 234,401 Appear Twice and Zero Disagree, Audited for Germany

Every chip resistor duplicate part number in Walsin’s catalogue is harmless. We parsed all 234,815 rows across 137 export files: 414 of 234,401 distinct part numbers appear on two rows, and zero of them disagree on resistance, tolerance, TCR, rated power, size, termination or packaging.

---

Venatech Limited, an authorised Walsin distributor in Hong Kong, holds all 203 of Walsin Technology (Walsin)’s parametric export files and 28 of its datasheets, 451 pages. The same audit on the MLCC side found 132 duplicated part numbers of which 124 disagreed on physical thickness, so we ran it on the resistor shelf rather than assume the answer transfers. Every part number below is real and sits in our extract.

How many Walsin chip resistor part numbers appear in more than one export file?

414. We counted all 234,815 rows in the 137 files of Walsin_ChipR_Product_Data and resolved them to 234,401 distinct part numbers. 414 of those appear on exactly two rows. Not one appears on three. The 828 affected rows are 0.35% of the catalogue, and every collision crosses a file boundary rather than repeating inside a single file.

Measurement, all 137 files	Count
Rows in the chip resistor export	234,815
Files that return at least one row	64 of 137
Distinct part numbers	234,401
Part numbers on two rows	414
Part numbers on three or more rows	0
Part numbers appearing in two different files	414
Files contributing at least one duplicate	5 of 137

73 of the 137 files return zero rows, so the real denominator for file-level work is 64. We opened each one. The duplication is concentrated in a way that a sampled check would miss entirely.

Do any of the 414 duplicated part numbers contradict each other on an electrical field?

No, and we checked every column the export carries. We grouped the 828 rows by part number and counted distinct values per field across all nine columns: Resistance, Tolerance, TCR, Rated Power, Size, Termination, Packaging, Series and Series Group. The number of part numbers disagreeing on any one of them is zero.

Field compared across both rows	Part numbers disagreeing
Resistance	0 of 414
Tolerance	0 of 414
TCR	0 of 414
Rated Power	0 of 414
Size	0 of 414
Termination	0 of 414
Packaging	0 of 414
Series	0 of 414
Series Group	0 of 414

That is the opposite of the MLCC result we published in the MLCC duplicate audit, where 124 of 132 duplicated codes carried two different physical thicknesses under one part number. We have not seen the resistor side of this counted anywhere. On the resistor shelf the duplicate is pure redundancy: the same part, stated twice, identically.

Which of the 137 chip resistor files actually collide?

Five files, in three pairs, and all five sit inside one series group. We measured the duplicate rate per file. Three of the 137 files are wholly contained in another file — every row they hold also appears somewhere else. Every one of the 414 collisions is inside Thick Film High Power Chip Resistor, a group holding 40,255 rows and 39,841 distinct part numbers.

File	Rows	Rows that duplicate another file	Share
HighPower__jumper__ONE_FIFTH_W.xlsx	1	1	100%
HighPower__tol5__ONE_FIFTH_W.xlsx	123	123	100%
Thick_Film_High_Power_Chip_Resistor_5_1_5W.xlsx	290	290	100%
Thick_Film_High_Power_Chip_Resistor_5.xlsx	6,913	413	6.0%
Thick_Film_High_Power_Chip_Resistor_Jumper.xlsx	33	1	3.0%
HighPower__tol1__ONE_FIFTH_W.xlsx	587	0	0%

The last row is the one worth staring at. HighPower__tol1__ONE_FIFTH_W.xlsx holds 587 rows at 0402, 1/5 W, ±1% and not a single one of them appears anywhere else in the 137 files. Its ±5% sibling, HighPower__tol5__ONE_FIFTH_W.xlsx, is 123 rows that are all already in Thick_Film_High_Power_Chip_Resistor_5.xlsx. Two files named on the same pattern, one fully redundant and one uniquely load-bearing.

Does normalising the 39,576 embedded spaces change the duplicate count?

Not by one part number. 39,576 of the 234,815 rows carry a part number with an embedded space — a known defect in this export, and the single most common reason a Walsin resistor code will not join against a BOM. We stripped every space and recounted. The distinct total stayed at 234,401 and the duplicate count stayed at 414.

Two measurements make that concrete. Zero of the 39,162 spaced part numbers collapse onto an existing space-free part number when the space is removed. And all 414 duplicated part numbers carry an embedded space — meaning zero of the 195,239 space-free part numbers in the catalogue duplicate at all.

So the naive count and the normalised count are the same number. That is not the result we expected, and it is the useful half of the finding: the space is deterministic per part number, not a stray typing error sprinkled across the file. 75 part numbers carry two spaces, every one of them a 1206 code of the shape WR12F1R0 JTL FN.

What do two duplicated rows look like side by side?

Identical on every field the export publishes, with only the source filename differing. We pulled four real examples, one from each collision pattern, and read both of their rows. The Match / mismatch column below is the comparison between the two rows of the same part number, not between two different parts.

Part number	Size	Resistance	Tolerance	TCR	Rated power	The two files it appears in	Match / mismatch between the two rows
WF20A100 JTL	2010 (5025)	10 Ω	±5%	≦±200	1.5 W	..._High_Power_Chip_Resistor_5.xlsx and ..._5_1_5W.xlsx	Match on all nine columns — redundant listing only
WF20A101 JTLJ	2010 (5025)	100 Ω	±5%	≦±200	1.5 W	..._High_Power_Chip_Resistor_5.xlsx and ..._5_1_5W.xlsx	Match on all nine; Series reads automotive on both rows
WF04A102 JTL	0402 (1005)	1,000 Ω	±5%	≦±100	1/5 W	HighPower__tol5__ONE_FIFTH_W.xlsx and ..._High_Power_Chip_Resistor_5.xlsx	Match on all nine — the smaller file adds nothing
WF04A000 PTL	0402 (1005)	0 Ω	Jumper	–	1/5 W	HighPower__jumper__ONE_FIFTH_W.xlsx and ..._High_Power_Chip_Resistor_Jumper.xlsx	Match on all nine; TCR is a literal dash on both
WF04A102 JTL versus WF20A101 JTLJ	0402 vs 2010	1,000 Ω vs 100 Ω	both ±5%	≦±100 vs ≦±200	1/5 W vs 1.5 W	different files	Mismatch on size, resistance, TCR and power — these are two different parts, shown for contrast

The last row exists to make the point that the first four are not doing. A duplicate here is one part with two rows. It is not two parts that look alike, and it is not a specification conflict you have to adjudicate.

Does a duplicate part number break a BOM check or a cross reference?

It inflates a candidate count and nothing else. A de-duplicating join over these 137 files is safe, because all nine published fields agree on all 414. What does break is the embedded space: 39,576 rows whose part number will not match a space-free string in your purchasing system, which is a far larger problem than 414 redundant rows and we wrote it up separately in why Walsin part numbers do not paste into your BOM.

For a German buyer this matters at one specific moment. If you build a candidate list by globbing the export folder, the 0402 1/5 W ±5% line will show 246 rows where 123 parts exist, and the 2010 1.5 W line will show 580 rows where 290 parts exist. Count parts, not rows. Our free cross-reference tool de-duplicates before it returns candidates, matched against Walsin’s published catalogue, and it states every difference from the part you pasted rather than calling anything a match it is not.

What should a German buyer do with a 414-part overlap?

Three things, and none of them costs more than an afternoon. The 414 are not a quality problem in the parts; they are a counting problem in the data, and the fix is to count distinct part numbers rather than rows before you report a shelf to your own engineering team.

1. De-duplicate on the part number, spaces included. Treat WF20A100 JTL as one line item even though it has two rows. 234,401 is the honest denominator for the chip resistor catalogue; 234,815 is the row count.
2. Cross the whole bill of materials in one pass. Paste up to 500 part numbers or drop your Excel or CSV into the free cross-reference tool, filter by commercial or automotive grade, and read the stated differences field by field.
3. Check what is physically in Hong Kong on ready stock before you commit a build slot. That page is a dated snapshot as at 23 September 2026, not a live feed.

AEC-Q200 is described by Walsin as compliant, never certified, and Venatech makes no qualification claim of its own — request the qualification report for your exact part number. The full line is on the Walsin chip resistor page.

The short version

We parsed all 234,815 rows in Walsin’s 137 chip resistor export files. 414 of 234,401 distinct part numbers appear on two rows; none appears on three. Zero of the 414 disagree on any of the nine published columns. Three of the 137 files are wholly contained in another file, and all five colliding files sit inside the High Power group. All 414 duplicates carry an embedded space, and stripping the 39,576 spaces changes the duplicate count by zero. 73 of the 137 files return no rows at all. We will not tell you a part is equivalent. We will show you where it differs — and here, on these 414, nothing does. Qualification stays with you.

Send us the chip resistor lines off your German bill of materials and we will tell you how many distinct part numbers you actually have, which of them carry an embedded space that your purchasing system will silently drop, and what was physically in Hong Kong on 23 September 2026. And if your selector reports 246 candidates at 0402 1/5 W ±5%, ask it how many part numbers that really is.

---

Frequently asked questions

<!– wp:rank-math/faq-block {"questions":[{"id":"faq-question-01","title":"How many Walsin chip resistor part numbers are duplicated across the export files?","content":"414 of 234,401 distinct part numbers, measured by us across all 234,815 rows in the 137 files of Walsin's chip resistor export. Each of the 414 appears on exactly two rows in two different files. None appears on three or more rows anywhere in the catalogue.","visible":true},{"id":"faq-question-02","title":"Do the duplicated chip resistor rows ever disagree on a specification?","content":"No. We compared both rows of all 414 part numbers across nine columns: resistance, tolerance, TCR, rated power, size, termination, packaging, series and series group. The count of part numbers disagreeing on any field is zero. The duplication is redundant listing, not a specification conflict.","visible":true},{"id":"faq-question-03","title":"Which Walsin chip resistor files contain duplicate part numbers?","content":"Five of the 137, in three pairs, all inside the Thick Film High Power group. Three are wholly contained in another file: HighPower__jumper__ONE_FIFTH_W.xlsx, HighPower__tol5__ONE_FIFTH_W.xlsx and Thick_Film_High_Power_Chip_Resistor_5_1_5W.xlsx. Their ±1% sibling file, with 587 rows, duplicates nothing.”,”visible”:true},{“id”:”faq-question-04″,”title”:”Does removing the embedded spaces create more duplicate part numbers?”,”content”:”No. We stripped every space from all 234,815 part numbers and recounted. The distinct total stayed at 234,401 and the duplicate count stayed at 414. Zero spaced part numbers collapse onto a space-free one, and all 414 duplicates carry a space already.”,”visible”:true},{“id”:”faq-question-05″,”title”:”Is it safe to de-duplicate a Walsin chip resistor list on the part number?”,”content”:”Yes, for these 137 files. Because all nine published fields agree on all 414 collisions, a de-duplicating join loses no information. The risk in this export is the embedded space on 39,576 rows, which breaks a join rather than inflating one.”,”visible”:true},{“id”:”faq-question-06″,”title”:”How does this compare with the Walsin MLCC duplicate audit?”,”content”:”It is the opposite result. On the MLCC side, 132 of 8,330 general purpose part numbers repeat and 124 of those carry two different physical thicknesses under one code. On the chip resistor side, 414 repeat and zero disagree on anything the export publishes.”,”visible”:true},{“id”:”faq-question-07″,”title”:”What should a buyer in Germany do about the 414?”,”content”:”Count distinct part numbers, not rows, before reporting a shelf internally. Then cross the bill of materials in one pass through the free cross-reference tool, read the stated differences, and check the dated Hong Kong snapshot as at 23 September 2026 before committing a build slot.”,”visible”:true}],”listStyle”:””,”titleWrapper”:”h3″,”titleCssClasses”:””,”contentCssClasses”:””,”sizeSlug”:””} –>

---