Groupby

[Anonymous]

Hi All,

i want to group by the below inline table on 'wo' column.

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

output

id,value

1,33

2,77

[Anil_Babu_Samineni · Accepted solution]

This?

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

NoConcatenate

final:

LOAD id, sum(value) as value Resident input Group By id;

DROP Table input;

[arvind_patil]

Dear Kulwant,

Please Find below Code:

input:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

DATA:

Load id ,Sum(value) As FinalValue Resident input Group By id;

thanks,

Arvind Patil

[Kushal_Chawda]

if you want tp do it on front end

Create the straight table on front end

Dimension:

ID

Expression:

Sum(Value)

[Anonymous]

Table1:

load * inline [

id, wo, value

1,a,11

1,b,22

2,a,33

2,b,44

];

NoConcatenate

Table2:

LOAD id,

sum(value) as value

Resident Table1

Group By id;

DROP Table Table1;

OP

id	value
1	33
2	77

Regards

Tahemas