topic Re: How to left join to a table from one file tables from multiple files? in QlikView

How to left join to a table from one file tables from multiple files?

mrthomasshelby — Thu, 01 Mar 2018 12:11:50 GMT

Hello,

I have 3 tables basically.

Table 1 as below:

Line#	No.	Country	Region	State	Location	Unit	LName	Feature1	Feature2	Feature3	Feature4	Feature5	Feature6	Feature7	Measure	Quant	Measure1	Estimate1	Estimate2

This Table 1 is loaded from a single excel file no problem.

Now, Table 2 headers are as below:

P.Name	Date	Name	Type	Model	Value	Currency	No.	LName	Vendor	Country	Region	State	Location	Unit	Type1	Cat1	Cat2	Cat Type	Year	H1	H2

This Table 2 is to be loaded from 5 excel files which have the same headers and format.

Table 3 headers are as below:

PName	Date	Name	Type	Model	Value	Currency	LName	No.	Vendor	Country	Region	State	Location	Unit	Feature1	Feature2	Feature3	Feature4	Feature5	Feature6	Feature7	Measure	H3

Again this table is to be loaded from another set of 5 excel files which have the same headers as above.

Now what I need to do is a Left Join of Table 2 and then Table 3 on Table 1.(Table 1 is Left).

What I have tried is as below:

Table 1:

Load *

FROM

[* Table1.xlsx]

(ooxml, embedded labels, table is XYZ);

Left Join

Table 2:

Load *

FROM

[*.xlsx]

(ooxml, embedded labels, table is ABC);

Left Join

Table 3:

Load *

FROM

[ *.xlsx]

(ooxml, embedded labels, table is DEF);

But I'm not getting the desired result as the join is not happening properly and most fields are being populated as blanks. Please help me achieve this. Thanks in advance!

Re: How to left join to a table from one file tables from multiple files?

Anil_Babu_Samineni — Thu, 01 Mar 2018 12:27:29 GMT

Do you understand the concept of Left Join in SQL Engine? How and which is keys will work in synthetically? The reason behind, My answer is might you don't have exact values which matching with another table?

Re: How to left join to a table from one file tables from multiple files?

mrthomasshelby — Thu, 01 Mar 2018 12:30:54 GMT

No, but the columns No., Country, Region, State, Location etc. are clearly present as common fields in the tables?

Re: How to left join to a table from one file tables from multiple files?

Anil_Babu_Samineni — Thu, 01 Mar 2018 12:38:07 GMT

May be cheek the Subset Ratio & Information Density for tables. So then we can easily understand the table where we are bending down?

Re: How to left join to a table from one file tables from multiple files?

mrthomasshelby — Thu, 01 Mar 2018 13:00:53 GMT

I found the answer in this thread:

https://community.qlikview.com/thread/246888

Thanks for your efforts!