another option of group by

[#1]

Hi all,

I am loading one table in which I need to perform group by on 15 fields. I have to do it group by in script only as it is not possible to do it in front end as per the requirement. I have heard that doing group by in script causes performance issue while loading the data. Can anyone suggest better option other than group by?

[sunny_talwar]

If you want to aggregate your data using Sum, Min, Max, ... etc, I don't think there is any alternative available. AFAIK I think you have use Group By. Having said that, we might it might be helpful to look at a sample with the expected output which might help us understand what you are trying to do and we might be able to offer some alternative (if there are any available)

[antoniotiman]

Hi,

You can use Aggr() function in front end instead of Group By in Script

E.g.

Sum(Aggr(Sum(Sales),ID))

instead of

SQL Select  ID,Sum(Sales) as TotalSales

From Table

Group By ID;

Regards,

Antonio