Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table created named TTT, I am trying to create more field with calculation for this table and create a new table named Table1
My loading script as below, please help me if I have done something wrong
Talbe1:
Load *,
A&B&C as ABC
D AS D_123
RESIDENT TTT;
JOIN (TTT)
LOAD
A&B&C as ABC,
A,
SUM(SALES) AS SALES_A
GROUP BY A;
JOIN (TTT)
LOAD
A&B&C as ABC
A,
B,
SUM(SALES) AS SALES_A_B
GROUP BY A, AND B;
Please provide the Table TTT
Table TTT has Field
A
B
C
D
sales
TTT:
Load * Inline [
A,B,C,D,Sales
10,20,30,40,130
];
Talbe1:
Load *,
A&B&C as ABC,
D AS D_123
RESIDENT TTT;
JOIN (Talbe1)
LOAD
A&B&C as ABC,
A,
SUM(A) AS SALES_A
RESIDENT TTT
GROUP BY A,B,C;
JOIN (Talbe1)
LOAD
A&B&C as ABC,
A,
B,
SUM(A)+Sum(B) AS SALES_A_B
RESIDENT TTT
GROUP BY A,B,C;
DROP Table TTT;
// After running this script I am getting the following output