Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ]
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 ]