Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have source data which has multiple fields with duplicate data. I am having trouble creating an expression to remove duplicates across multiple fields.
Example of data:
SERIAL NUMBER | OPERATION | DEFECT CODE | DEFECT LOCATION
123 SMT TOMBSTONE U1
123 SMT SOLDER BRDGE C25
123 XRAY TOMBSTONE U1
123 XRAY SOLDER BRDGE C25
234 SMT TOMBSTONE U5
234 SMT SOLDER BRDGE C28
234 XRAY TOMBSTONE U5
234 XRAY SOLDER BRDGE C28
What I am trying to figure out is this.
If the Serial Number, Defect Code & Defect Location match then the qty is 1, regardless of the operations they are recorded against.
Expected Results -
Serial # | Defect Code | Defect Location | Qty
123 Tombstone U1 1
123 Solder Bridge C25 1
234 Tombstone U5 1
234 Solder Bridge C28 1
I hope this makes sense; I am a novice so any help will be appreciated.
Could this expression be what you are looking for?
Count (distinct [Serial Number] & [Defect Code] & [Defect Location])
Could this expression be what you are looking for?
Count (distinct [Serial Number] & [Defect Code] & [Defect Location])
Yes, that worked. Appreciate your help, Thank you!