Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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
if you want tp do it on front end
Create the straight table on front end
Dimension:
ID
Expression:
Sum(Value)
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