topic Re: Tricky Join .... in QlikView

Tricky Join ....

Anonymous — Fri, 19 Dec 2014 09:35:01 GMT

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

Re: Tricky Join ....

richard_pearce6 — Fri, 19 Dec 2014 09:38:07 GMT

Hi Phil,

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

Richard

Re: Tricky Join ....

richard_pearce6 — Fri, 19 Dec 2014 09:40:39 GMT

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

Re: Tricky Join ....

Anonymous — Fri, 19 Dec 2014 09:53:13 GMT

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

Re: Tricky Join ....

manojkulkarni — Fri, 19 Dec 2014 09:55:54 GMT

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