topic Re: How to do Aggregation without using taggregateRow component? in Talend Studio

How to do Aggregation without using taggregateRow component?

Anonymous — Thu, 24 May 2018 13:33:28 GMT

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?

Re: How to do Aggregation without using taggregateRow component?

vboppudi — Thu, 24 May 2018 15:45:26 GMT

Hi,

Are you looking for the following output?

Regards,

Re: How to do Aggregation without using taggregateRow component?

Anonymous — Fri, 25 May 2018 15:43:17 GMT

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

Re: How to do Aggregation without using taggregateRow component?

manodwhb — Mon, 28 May 2018 10:25:15 GMT

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

Re: How to do Aggregation without using taggregateRow component?

Anonymous — Mon, 04 Jun 2018 10:36:15 GMT

@manodwhb @vboppudi

Thanks a lot for your help.