Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

join issue

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.

7 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

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.

alexandros17
Partner - Champion III
Partner - Champion III

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

robert_mika
Master III
Master III

If worker or worker Id is not primary Key.

Try

Worker&WorkerId as Key

in both tables

Anonymous
Not applicable
Author

Hi Please find the sample application

Thanks

Anonymous
Not applicable
Author

Hi  Alessandro ,Robert

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

Thanks in advance

robert_mika
Master III
Master III

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

23-Jul-15 10-53-10 AM.jpg

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

Kushal_Chawda

Provide test data also