Matching on approximate time

[craigja]

Hi,

I have a problem where Im trying to join  2 datasets together - in order to do this im matching on the buyer and seller, price and time.  The time bit is causing me an issue as in 1 dataset it might be 14:39:00 and in the other dataset the time might be 14:40:00.  Is there any way I can match on approximate time?  Fuzzy match was my first port of call but it seems this is really only suitable for string/text fields

[ChrisTX · Accepted solution]

Check out the Generate Rows tool

Here are a few related posts; most are using a date match.  You'll need to adjust the logic for a time match.

Alteryx Weekly Challenge #1: Join to Range

It is a good example to show the usefulness of the generate rows tool.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-1-Join-to-Range/td-p/36621

Datetime approximate match between two sources

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Datetime-approximate-match-between-two...

Joining Approximate Matches

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Joining-Approximate-Matches/m-p/142850...

Advanced Join tool: value from one file is between, > or < a value from another file

Community > Designer > Browse Knowledge > Advanced Join: value from one file is between

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Advanced-Join-value-from-one-file-is-between...