how do i arrange feilds according to the given data

[saniyask]

table1

Region	SubRegion	Data
R1	SB1	1
R1	SB2	5
R1	SB3	7
R2	SB4	9
R3	SB5	10
R4	SB6	7
R4	SB7	8
R5	SB8	9

OUTPUT

SB1	1
SB2	5
SB3	7
R1	13
SB4	9
R2	9
SB5	10
R3	10

HOW WILL I GET THE DESIRED OUTPUT

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[sunny_talwar]

May be this:

Table:

LOAD * Inline [

Region,     SubRegion,      Data

R1,               SB1,                    1

R1,               SB2,                    5

R1,               SB3,                    7

R2,               SB4,                    9

R3,               SB5,                    10

R4,               SB6,                    7

R4,               SB7,                    8

R5,               SB8,                    9

];

Concatenate(Table)

LOAD Region as SubRegion,

           Sum(Data) as Data

Resident Table

Group By Region;