Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Tricky Join ....

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 appointments

Health Appointment Date

Person First Name

Person Last Name

Person DOB

Health reason

HealthAppt_Person_ID

Person Table

Person First Name

Person Last Name

Person Staff Number

Person DOB

HealthAppt_Person_ID

Roster_Person_ID

Roster Table

Roster Date

Roster Shift Name

Person Staff Number

Person First Name

Person Last Name

Roster_Person_ID

How do I show what shift the person was working on the date of the Health Appointment (without duplications)?

Thanks in advance

Phil

4 Replies
Highlighted
Luminary
Luminary

Hi Phil,

Hope you're well. Probably be an interval match join. If you could supply some sample data that would be great.

Richard

Highlighted
Luminary
Luminary

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

Rich

Highlighted
Creator II
Creator II

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

Highlighted
Partner
Partner

Joining to Roaster table will get you the required details. Need to take care of synthetic keys going to build with other table.