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.
