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 (Talbe1)
LOAD
A&B&C as ABC,
A,
SUM(SALES) AS SALES_A
RESIDENT TTT
GROUP BY A;
JOIN (Talbe1)
LOAD
A&B&C as ABC
A,
B,
SUM(SALES) AS SALES_A_B
RESIDENT TTT
GROUP BY A, AND B;
Like this??
Talbe1:
Load *,
A&B&C as ABC
D AS D_123
RESIDENT TTT;
JOIN (Talbe1)
LOAD
A&B&C as ABC,
A,
SUM(SALES) AS SALES_A
RESIDENT TTT
GROUP BY A , ;
JOIN (Talbe1)
LOAD
A&B&C as ABC
A,
B,
SUM(SALES) AS SALES_A_B
RESIDENT TTT
GROUP BY A, AND B ,A&B&C;