Left Join: too many rows

[qlikviewaf]

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;

[Anonymous]

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

[qlikviewaf]

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

[Anonymous]

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