Discussion Board for collaboration on QlikView Scripting.
I am trying to link my health appointments to the rostering info so I can understand what shift someone was working on the day they attended a health appointment.
I have the following tables :
Health Appointment Date
Person First Name
Person Last Name
Person Staff Number
Roster Shift Name
How do I show what shift the person was working on the date of the Health Appointment (without duplications)?
Thanks in advance
Hope you're well. Probably be an interval match join. If you could supply some sample data that would be great.
Actually thinking about it the join could be as simple as a concatenation which the odd field rename here and there. again some sample data will help loads
You can left join the person table with roster table, as u need all the information from roster table, and if you want data from both the tables then a simple join will do
Joining to Roaster table will get you the required details. Need to take care of synthetic keys going to build with other table.