I am having trouble getting my IntervalMatch function to work properly. I have posted my script below.
My end goal is to join the %SessionKey% from the Actions table to the Sessions table. I am trying to do this by first matching the Action Timestamp to the correct Session_Start and Session_End Interval. I need to add a key to the IntervalMatch in order to make the records more unique, which is why %IntervalKey_Actions% and %IntervalKey_Sessions% were created. Once the correct timestamp and key are associated on the Sessions table I want to then left join in the %SessionKey%. When I run my script below I get two synthetic tables. Any help on how to solve this would be appreciated. Thanks!
tmpDate&'-'&UPPER([Action Document])&'-'&UPPER([Action User]) as %IntervalKey_Actions%,
Drop table tmp2_Actions;
Session_Date&'-'&UPPER(Document_Name)&'-'&UPPER(UserId) as %IntervalKey_Sessions%,