Forum Discussion
JeffWeir
Advocate V
Advocate VMultilple recursive Inner and Anti Joins for robust fuzzy date matching - Can List.Accumulate help?
I’m trying to reconcile data from two different entities regarding movement of shipping containers, by doing a bulletproof fuzzy match on dates. One is a shipping port, the other is a railway. ...
JeffWeirAdvocate V
Advocate VImkeFThat Sorted Rows > Remove Duplicates step is clever.
I'll tweak my code to use this approach and see if there is a performance improvement. I still need to do lots of different passes, because i want this to be a 'progressive' match, so it may not simplify the query chain overly. But it will be interesting to see if there's any performance difference. Thanks :-)
ImkeF
Community Champion
Community ChampionHi JeffWeir
this apprach was supposed to replace your whole chain. I've tweaked to code a little bit to come up with the correct Table2, but now it delivers all you need. No need at all to go through all these iterations. (results are shown in row 42 -57 of Sheet1)
Please check the results in the attached file.