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?
Thanks in advance!
Solved! Go to Solution.
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].
Thank you @soccertil1108 I have downloaded and will review with my data set later today. This seems so simple. I will provide feedback later and either ask more questions or accept. Thanks again!
Thank you again @soccertil1108 That was so simple and elegant,.. but did take a lot of thinking to perfect! I appreciate your assistance!
Glad to assist. And, I realized that my non-equi join video was never converted to my YouTube page, so I have a new video to work on!!