Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
philmywallet
New Contributor III

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

Tags (3)
4 Replies
Luminary
Luminary

Re: Tricky Join ....

Hi Phil,

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

Richard

Luminary
Luminary

Re: Tricky Join ....

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

karunpreet
Contributor

Re: Tricky Join ....

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

manojkulkarni
Valued Contributor II

Re: Tricky Join ....

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

Community Browser