0 Replies Latest reply: Jun 14, 2015 2:53 PM by Андрей Шепель RSS

    Missing values in connection tables in load script

    Андрей Шепель

      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_IDDistributor_Id
      1688345321
      1688364916
      168837639
      1688376518
      1688375714
      1688376415
      1688293727
      1688345110
      168826005
      1688345212
      168837586
      168826014
      1688345411
      168832393
      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.