How to do Aggregation without using taggregateRow component?

[Anonymous]

Hi,

I need to perform aggregation like sum and count on my data.But the case is I can not use taggregateRow component.

for example I have data set like

cust_id|cust_name|cust_rec_type|amount
1|john|BP|8000
2|jeevan|SR|8900
3|jay|BP|8078
4|harish|BS|8000
1|john|BP|800
6|Anshul|PR|20000
3|jay|BP|808
2|jeevan|SR|800
9|john|SR|8900
2|jeevan|SR|80

I want to perform group by on cust_id and sum of amount for each cust_Id.

Can anybody tellme how can I achieve this?

[vboppudi · Accepted solution]

Hi,

Are you looking for the following output?

Regards,

[Anonymous]

HI,

Thanks a lot for this suggestion. I tried exact same way. but getting different output as below PFA screenshots.

1|john|BP|8800|2
2|jeevan|SR|18580|5
3|jay|BP|27466|7
4|harish|BS|35466|8
6|Anshul|PR|55466|9
9|john|SR|64366|10

can you please suggest on this

Untitled.png

[manodwhb]

@sourabh93,you move the pre_cust_id variable port to down the all variable fields,your issue will be fixed. 

[Anonymous]

@manodwhb @vboppudi

Thanks a lot for your help.