Hi,
Any suggestion on this would be appreciated.
I have 3 tables A,B and C from Oracle.I joined these three tables and create a final memory table in qlikview called CALL.Same way I have two other tables from SQL,joined those two and build a table called AGENT.
CALL has these fields KEY,Call_Start_Dt,Call_End_dt,Duration
AGENT has these fields KEY,Name,Age,Agent_Begin_Dt,Agent_End_Dt
I need to join CALL and AGENT where Call_Start_Dt >=Agent_Begin_Dt and Call_Start_Dt<=Agent_End_Dt
Can someone let me know what is the best way to achieve this.
Thanks......
