topic Left Join: too many rows in QlikView

Left Join: too many rows

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i'm joining 2 tables.

For the first table the statement says "First 100 load" from TABLE1 ( to just load the first 100 records).

then i have the part table to be joined as left join (TABLE2) i don't no why seems that all the TABLE 2 is loaded and not only based on the value coming from the first 100 rows of TABLE1.

Any advice on this?
Thanks

TABLE2:

Left Join (TABLE1)

Load

ABAN8 as ShipTo;

SQL SELECT *

FROM JDE90.PRODDTA.F0101;

Re: Left Join: too many rows

Anonymous — Fri, 09 Jun 2017 15:03:46 GMT

does Table 1 contain a Field called "ShipTo" and do you have a 1 to 1 relationsship?

Re: Left Join: too many rows

qlikviewaf — Fri, 09 Jun 2017 15:04:44 GMT

Yes correct. The table 1 has a field called ShipTO which is the link between the 2 tables

Re: Left Join: too many rows

Anonymous — Fri, 09 Jun 2017 15:10:37 GMT

could be that 1 table contains a text and the other table a dual() value and then they don't match.

try the following:

TABLE1

YourField as ShipTo,

ShipTo as ShipTo_Table1;

TABLE2:

Left Join (TABLE1)

Load

ABAN8 as ShipTo,

ABAN8 as ShipTo_Table2;

;

SQL SELECT *

FROM JDE90.PRODDTA.F0101;

--------------------------------------------------------------

Then create a table box and add ShipTo, ShopTo_Table1 and ShopTo_Table2 and have a look, if "matching" values are in the same row...

Could also be that you have a problem with spaces...