Missing values in connection tables in load script

Anonymous — Sun, 14 Jun 2015 15:29:55 GMT

Good day!

In load script i have three tables:

Sales:

Distributor_id

Route_Id

Link_Table:

Distributor_id

Nomenclature_id

Date

Distributors:

Distributor_id

Distributor_name

But when i add to table Sales two fields Nomenclature_id,Date, make autonumberhash key and connect it with link table:

Sales:

load

Distributor_id

Nomenclature_id,

Date,

Route_Id

autonumberhash128(Distributor_id,Nomenclature_id, Date) as Key

from...

outer join(Link_Table)

load

Distributor_id

Nomenclature_id,

Date,

Key

resident Sales;

drop fields Distributor_id,Nomenclature_id,Date from Sales;

i have missing values in field Route_id in result, when i make straight table with fields Distributor_id, Route Id:

I think, problem connected with values Nomenclature_id,Date in Link Table (they have some values, which are not match in table Sales)

Have anyone idea how to connect correctly these three tables?

Thanks.

topic Missing values in connection tables in load script in QlikView