topic Re: join issue in QlikView

join issue

Anonymous — Thu, 23 Jul 2015 08:00:13 GMT

i have 2 tables.

1.head Count

2.spend

head count:

[Job Posting Title],

[Worker: Worker Supervisor],

[Worker: Worker Supervisor] as [Hiring Manager],

Worker,

[Worker ID],

Status,

[Start Date],

[End Date],

"Current Bill Rate [ST/Hr]",

[Physical Location of Worker],

[Worker Closed Date],

[Cumulative Committed Spend],

[Total Spend]

Spend:

Worker,

[Worker ID],

[Job Posting Title],

[Worker Status],

[Worker: Worker Supervisor],

[Worker Start Date],

[Worker End Date],

[Invoice Submit Date],

[Invoice Amount],

"Bill Rate [ST/Hr]",

"Bill Rate [OT/Hr]"

I want join these two tables.

worker Id is not primary key, frequency its showing 2 for @some id's

Worker Name also not primary key ,frequency its showing 2 for some Workers

how to proceed further,any idea would be greately appreciated.

Re: join issue

manojkulkarni — Thu, 23 Jul 2015 08:28:54 GMT

I don't see any issue with this, still you can join with WorkerID. If you upload some sample data , then it will provide clear picture of data.

Re: join issue

alexandros17 — Thu, 23 Jul 2015 08:33:54 GMT

I think there are not real problems because for each worker you can have more that one expense

Re: join issue

robert_mika — Thu, 23 Jul 2015 08:36:43 GMT

If worker or worker Id is not primary Key.

Try

Worker&WorkerId as Key

in both tables

Re: join issue

Anonymous — Thu, 23 Jul 2015 09:37:35 GMT

Hi Please find the sample application

Thanks

Re: join issue

Anonymous — Thu, 23 Jul 2015 09:40:28 GMT

Hi Alessandro ,Robert

can u please review my sample application and provide me your suggestion

Thanks in advance

Re: join issue

robert_mika — Thu, 23 Jul 2015 09:55:45 GMT

As Allesandro pointed there can be multiple instances foe each employee to example this:

You can either comment out the fields that bring you double values or not load them or find out which Supervisor is the correct one

Re: join issue

Kushal_Chawda — Thu, 23 Jul 2015 10:03:14 GMT

Provide test data also