This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
- edited on
In SQL, you can join on a range, using code similar to the below snippet.
SELECT Column, FruitName, StartDateTime, EndDateTime
INNER JOIN dbo.Greek_Alphabet ON dbo.DateTime BETWEEN dbo.FruitList_StartDateTime AND dbo.FruitList_EndDateTime
Alteryx does not have a "join on range" command, but you can get the same result by appending all records and using a filter tool.
Is there any plans to build a dedicated join on range tool at all? Appending all records, or creating records then discarding them as suggested in the Join on date range articles, can be very impractical when dealing with large data sets
When you are working with billions of rows of data and joining it with at least 10s of millions
an append will result in catastrophic compute times and will need huge disks I suppose...
An In-db version would be easier to build I believe...
This has to be a joke right? There is no other way to join between a range? I have a request where this will cause millions of unnecessary lines and processing.