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

[Anonymous · Accepted solution]

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

[boorgura]

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.

[#4]

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

[#5]

Thank you Rakesh!

[Anonymous]

Hi Yun,

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

[#7]

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

[Anonymous]

Let me check that

[Anonymous]

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.

[#10]

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".