I need to review thousands of the projects and start times on the left (A and B) and assign them to the time frame where they fell during that day (D,E,F). These values are fluid...they change daily. These data points are NOT in the same page - I just made this photo below for easy reference.
I did manage to work this with an APPEND tool. However, I'm just doing 2 days of data over several employees and I have 153 million rows (which I'll bring back to normal with the following filter tool), but I need to add much more data. Is there any other way?
As I was planning my next YouTube video on Non-Equi joins I had a major insight into a solution for your problem. I realized how the execution planner for an RDBMS would efficiently resolve the SQL Select query for your non-equi join. Alteryx enables me to implement the same solution very efficiently [4.4 seconds on my machine with a step to identify the out of range records and finishing with a couple of Browse].