How to do Aggregation without using taggregateRow component?

Five Stars

How to do Aggregation without using taggregateRow component?

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?

 


Accepted Solutions
Nine Stars

Re: How to do Aggregation without using taggregateRow component?

Hi,

 

Are you looking for the following output?

Aggregation1.PNGAggregation2.PNGAggregation3.PNG

Regards,

Veeru Boppudi
Five Stars

Re: How to do Aggregation without using taggregateRow component?

HI,

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

Untitled.pngUntitled1.png

 

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

Thirteen Stars

Re: How to do Aggregation without using taggregateRow component?

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

Manohar B

All Replies
Nine Stars

Re: How to do Aggregation without using taggregateRow component?

Hi,

 

Are you looking for the following output?

Aggregation1.PNGAggregation2.PNGAggregation3.PNG

Regards,

Veeru Boppudi
Five Stars

Re: How to do Aggregation without using taggregateRow component?

HI,

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

Untitled.pngUntitled1.png

 

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

Thirteen Stars

Re: How to do Aggregation without using taggregateRow component?

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

Manohar B
Five Stars

Re: How to do Aggregation without using taggregateRow component?

@manodwhb @vboppudi

Thanks a lot for your help.