Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached example.
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;