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
Solved! Go to 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
Joining Approximate Matches
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