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

[Anonymous]

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?

[devarasu07 · Accepted solution]

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 ]