18 Replies Latest reply: Jan 5, 2015 4:52 PM by Michael Solomovich RSS

    Loops in joing tables

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

      Good day!

       

       

      in lscript i'm trying to load tables:

       

      WorkingDays:

      LOAD

      Work_schedule,

          Дата,

          Status

      FROM

      $(DataPath)WorkingDays.xls

      (biff, embedded labels, table is [WDays$])

      where Дата < today(1);

       

      WorkingShedule:

      LOAD

        Distributor_Id,

        Work_schedule

        FROM

      $(DataPath)WorkShedule.xls

      (biff, embedded labels, table is [WShedule$]);

       

      Also i have link_ table, which have key fields:

      Дата,

      Distributor_Id

       

       

      When i do reload model, i see message with error:

       

      Structure of model:

       

       

      How i can make join between tables WorkingShedule, WorkingDays, Link_table without having loops in database structure?

       

      Source files of tables WorkingShedule, WorkingDays are in attached files

       

      Thanks.