AnsweredAssumed Answered

Need Fast Method to Compare MultiKey Lists

Question asked by jlb on Dec 12, 2011
Latest reply on Dec 22, 2011 by MicheleOlson

I am looking to see if anyone has a fast method for comparing two long/large multikey fields.

 

In current situation

 

FieldA - Multi-Key List of SN's - 31,961

FieldB - Multi-Key List of SN's - 14,281

 

FieldC - Multi-Key List of SN's from A, not in B.

 

I have tried the custom function ZapValues from Brian Dunning's website, and

I created a script that loops through the lists

 

(Script Image Attached)

Screen Shot 2011-12-12 at 4.27.29 PM.png

 

both approaches result in the correct answer for FieldC, but come with a HUGE time expense.

 

Any ideas on a better (faster) method.

 

JLB

Outcomes