1 Reply Latest reply: Jul 31, 2017 9:47 PM by Devarasu R RSS

    How to link Transactional table and Goals table with a common office field

    Carlos Maldonado

      Hi, I have the following situation:

      Office:

      Id        Address

      1          London

      2          Munich   ...

      Customer:

      Id    Name    Office(Afiliation)

      1      Carlos      2

      2      George    1   ....

      Goals:

      (Afiliation) 

      IdOffice  IdCategory    QtyCustomers

      1            1                    3

      1            2                    2

      2            1                    1   ...

      Category:

      Id    Name

      1    Food

      2    Clothes  ...

      Afiliations:

      IdCustomer    IdCategory    Misc      

      2                    1                    AAAA

      1                    2                    BBBB                          

      4                    1                    CCCC    ...


      I need to do an analysis by Office, count the quantity of afiliations per category against the goal set per category to that office. I get the Circular reference warning because office is related to Customer and Goals, Any ideas how to solve this?

        • Re: How to link Transactional table and Goals table with a common office field
          Devarasu R

          Hi,

          by renaming column name should work, try like below, Tks

           

          Office:

          LOAD Id as IdOffice,Address INLINE [

          Id,Address

          1,London

          2,Munich

          ];

          Customer:

          Load Id as IdCustomer,Name,[Office(Afiliation)] inline [

          Id,Name,Office(Afiliation)

          1,Carios,2

          2,George,1

          ];

           

          Category:

          load Id as IdCategory,Category  Inline [

          Id,Category

          1,Food

          2,Clothes];

           

          Goals_Afiliation:

          load * Inline [

          IdOffice,IdCategory,QtyCustomers

          1,1,3

          1,2,2

          2,1,1];

           

          Afiliations:

          load * Inline [

          IdCustomer,IdCategory,Misc 

          2,1,AAAA

          1,2,BBBB

          4,1,CCCC ]