add more columns with calculation for exist table

[yink-hpv]

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;

[jerryyang756]

Please provide the Table TTT

[yink-hpv]

Table TTT has Field

A

B

C

D

sales

[jerryyang756]

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