topic Re: Load Issues - Data not match in QlikView

Load Issues - Data not match

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 13:38:11 GMT

The issue for the delimeter space , the right spacing should be given when defining the column header and also the data listed in the inline table. Please check the attached app and screen shot which will help you with the issue

Re: Load Issues - Data not match

boorgura — Mon, 18 Jul 2016 13:43:46 GMT

You specified the delimiter as a single space - whereas your data has 2 spaces in between them - and hence the mismatch. As well - the data has 2 spaces - but column/field names have only one space.

Everything has to be uniform

Personal suggestion - to avoid spaces as delimiters if possible.

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:24:53 GMT

Thank you so much Vinay for spending your time and taking look at it. It works. And I will remember the format rule.

Do you mind take a look the updated QVW? As I have a Case_ID "10001" has multiple Case_Number. So it should have multiple Company_Name. However, one of the Company_Name is null value. I am not sure why this happened.

Thanks,

Becky

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:25:21 GMT

Thank you Rakesh!

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 14:28:59 GMT

Hi Yun,

Is it fixed now. i See Rakesh response. please let me know if you need further help

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:32:11 GMT

Hi Vinay,

The format issue have been fixed. However, I have another issue that hope you can take a look at it. I just sent you the updated QVW. Please let me know any of your thoughts. Thanks!

Becky

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 14:35:25 GMT

Let me check that

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 14:41:39 GMT

Hi Becky,

As per your data it is working fine. Can you please recheck the data. This is my suggestion on how you could understand properly. Put exit script after each load and you will understand how it works . Let us know if you any more issues.

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:47:35 GMT

I know must be the Load of "Company_Contact" table has issue. But I don't understand why the Company_Name -- "CompanyB" didn't show up with Case_Number "20150789" and Company_ID "002".

Re: Load Issues - Data not match

boorgura — Mon, 18 Jul 2016 14:49:52 GMT

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.

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 14:53:38 GMT

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

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:55:18 GMT

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

Re: Load Issues - Data not match

Mon, 18 Jul 2016 14:56:28 GMT

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

Re: Load Issues - Data not match

Anonymous — Mon, 18 Jul 2016 14:56:52 GMT

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