Load Issues - Data not match

[#1]

Hello,

I have 4 tables Case_Report (Case_ID, Case_Number), Case_Detail (Case_Number, Company_ID, Country_ID), Company_Contact ( Company_ID, Company_Name, Country_ID) and Country (Country_ID, Country_Name). I want to join these tables into Case_Report table. Therefore those data fields can be linked with other relevent data fields.  However, It shows weired result in my list boxes.

And if I changed the Join to Left Join for table "Company_Contact", the data fields Company_Name and Country_Name would either show in Grey color or won't show up after I clicked on any of the Case_ID.

Here I attached a Example QVW. I used Inline load in the example just to present what are my tables and data fields looks like. Can you let me know where was wrong?

Thanks in advance for your help!

Becky

[boorgura]

Looks like it is a data issue.

In case detail table - you say - for Case# 20150789 - it's company ID 002 from country_ID 40

whereas in Company Contact - you say, for company_ID 002 --> you say its Company_Name companyB and Country_ID 30.

when you join these - there are 2 fields with same name 0 Company_ID and Country_ID - so Qlik will try to match both the fields, and will not find any common records.

Hence the NULL.

** You might want to eliminate the Country_ID from any one of the tables.

[Anonymous]

because of the country_id in your case detail you have 40 but where as in company_contact you have listed it as 30. that's where your join has broken

[#4]

Thanks so much Rakesh. This is very helpful. I will need to think about how to and where to eliminate the Country_ID.

Appreciate your help!

Becky

[#5]

I got it. Rakesh also had a suggestion. Let me work on it. Thank you Vinay!

[Anonymous]

if that helps you please mark it as helpful too. so that way it will be helpful to the community