Forum Discussion

JeffWeir's avatar
JeffWeir
Icon for Advocate V rankAdvocate V
7 years ago

Multilple 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.   ...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
7 years ago

Hi 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. 

 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
7 years ago

Hi JeffWeir 

have you had a chance to test this out on your real data?

I'd be interested to hear how this scales on a large dataset.

 

Please mark my answer as solution if it solved your case - thanks.

 

  • JeffWeir's avatar
    JeffWeir
    Icon for Advocate V rankAdvocate V
    7 years ago

    Sorry ImkeF I've been away. I'll take a look later this week and post back.