Data inconsistency

[nikhilgarg]

Hey,

I have a qstn.

I have following data:

Col1     Col2    Col3   Col4   Col5  Total 

212       ABC    0       12        0        12

212       ABC    0       11        0        11

212       ABC    0       0         9        9

212       ABC    64      0        0        64

I want all these multiple entries to come in a single line like:

Col1     Col2    Col3   Col4   Col5  Total 

212       ABC    64      23        9         96

How can i obtain this??

thanks

[PrashantSangle]

Hi,

What is your expression for Col3,Col4,Col5,Total???

Use Sum(Col3), Sum(Col4), Sum(Col5)

Regards

[robert_mika]

t1:

load * Inline

[ Col1     ,Col2  ,  Col3,   Col4 ,  Col5,  Total

212       ,ABC ,   0 ,      12,        0,        12

212       ,ABC ,   0 ,      11 ,       0 ,       11

212       ,ABC ,   0  ,     0   ,      9  ,      9

212       ,ABC  ,  64,      0     ,   0     ,   64

]

;

t2:

LOAD

Col1 as col1,

Col2 as col2,

SUM(Col3) as col3,

Sum(Col4) as col4,

Sum(Col5) as col5,

Sum(Total) as total

Resident t1

Group by Col1,Col2;

drop Table t1;

[nikhilgarg]

Hey ,

Thanks but col3, col4, col5 are my expressions and not dimensions so cannot

use it at script level.

[PrashantSangle]

Hi,

What is the expression???

and do you have any extra dimension than only col1,col2

Regards

[robert_mika]

SO as max suggested use your current columns  with SUM()

[nikhilgarg]

Hey Thanks but i want to show only State = 'Accepted'. How can i acheive this?

[robert_mika]

Could post your app?

[nikhilgarg]

PFA..

[PrashantSangle]

What is your expected Output in provided example????

Regards