Keep or toss a part on one bad measurementI have a data set of 45 parts with 50 measurements across the surface of the part. If even one measurement is below the minimum I want to discard the part. I've made a column with an if/then that returns either "Too Thin" or "Good" but that is for each discrete measurement. I want a list that is just "Keep" or "Recycle" by part (lab time is restricted due to the pandemic, so I want to be efficient). I feel like I'm close but not close enough! A script answer would be helpful.
Data TableRe: Keep or toss a part on one bad measurementHi,
A simple trick I use is to code the single measure Pass / Fail as 1 and 0 (similarly to out you have done) and then add a new column where you calculate the Column Minimum of Pass / Fail by Part (Col Minimum(:Pass-Fail, :Part)). This will return 1 only for the parts where all measurements were set a 1, and will return 0 for any part where at least 1 measurement failed.
Best,
Thierry
