HI, totalt stop in the head.
I got this table with data:
I want to compile the results like this:
Try like below
Cust:LOAD * INLINE [CustSellerID, CustBuyerID, Amount4, 5, 30001, 7, 1304, 3, 3006, 4, 200];
FCust:LOAD CustSellerID as Customer, Sum(Amount) as Sell Resident Cust Group by CustSellerID;JoinLOAD CustBuyerID as Customer, Sum(Amount) as Buy Resident Cust Group by CustBuyerID;
DROP Table Cust;
View solution in original post