8 Replies Latest reply: May 30, 2014 6:23 AM by Pradip Sen RSS

    How to resolve this loop?

      Hi all,

       

      I am facing this issue and could not resolve. Appreciate if someone can guide me along.

      Basically, I have tried to create key between various tables hoping that it could synchronize the data but it failed.

       

      If I add in the 2 fields (Attribute 1 and 2), then it fails. Otherwise, it works.

      Really need to know the walk around for this, thanks.

       

      Below is the scenario:-

      ActualSalesTable:

      LOAD

           Store,

           Item,

           ActualSales,

           Date,

      SQL SELECT *

      FROM $(DB)$(Comp1)$ActualSalesTable";

       

      ItemTable:

      LOAD

           Item,

           Attribute1,

           Attribute2,

      SQL SELECT *

      FROM $(DB)$(Comp1)$ItemTable";

       

      FiscalYearTable:

      LOAD

           Date,

           Day,

           Week,

           Month,

           Year,

           YearWeek

      FROM Excel;

       

      BudgetSalesTable: (OK)

      LOAD

           Year,

           Week,

           BudgetSales,

           YearWeek

      FROM Excel;

       

      BudgetSalesTable: (NOT OK AFTER ADDING IN Attribute 1 and 2 -> Failed to synchronize due to loops)

      LOAD

           Year,

           Week,

           Attribute1,

           Attribute2,

           BudgetSales,

           YearWeek,

      FROM Excel;