Missing values in connection tables in load script

[Anonymous]

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:

ROUTE_ID	Distributor_Id
16883453	21
16883649	16
16883763	9
16883765	18
16883757	14
16883764	15
16882937	27
16883451	10
16882600	5
16883452	12
16883758	6
16882601	4
16883454	11
16883239	3
	3
	4
	5
	6
	9
	10
	11
	12
	14
	15
	16
	18
	21
	27

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.