cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Add fuzzy join / asof merge / join by columns which do not have exact matches

Allow joining two data tables based on not exact matches. I come across situations where I have to be able to join two databases (tables) together based on timestamp which aren't exact matches. This would allow me to do it based on those timestamps. The joins could also be based on string-similarities but I haven't (yet) come across situations where I would need to do that.

 

Continuous column join should let user to define tolerance and allow using grouping column(s).

 

Below are some example packages, which can provide some ideas on what type of joins and options would be helpful:

There are couple of scripts found from JMP Community which can do this (or parts of this), but it would be helpful to have this possibility directly built in JMP:

1 Comment
hogi
Level XII

Please also consider "fuzzy merge" in higher dimensions, like in this post:
How do I add data from one table to another table based on the distance