# Group by and Memory group by

**URL:** <https://community.automationedge.com/t/group-by-and-memory-group-by/17469>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [January 28, 2026, 1:05pm UTC](https://community.automationedge.com/t/group-by-and-memory-group-by/17469 "2026-01-28T13:05:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Atharvavanarase](https://avatars.discourse-cdn.com/v4/letter/a/c5a1d2/32.png) [@Atharvavanarase](https://community.automationedge.com/u/Atharvavanarase)\
**Post date:** [January 28, 2026, 1:05pm UTC](https://community.automationedge.com/t/group-by-and-memory-group-by/17469/1 "2026-01-28T13:05:30Z")

</div>

What is difference between group by and memory group by ? and what if we don’t define group field then what will happens, still it works?

---

<div class="post-metadata">

**Author:** ![AETrainings](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@AETrainings](https://community.automationedge.com/u/AETrainings)\
**Post date:** [January 29, 2026, 1:34pm UTC](https://community.automationedge.com/t/group-by-and-memory-group-by/17469/2 "2026-01-29T13:34:07Z")

</div>

Group By works on pre-sorted data and is suited for large datasets, while Memory Group By aggregates unsorted data in memory, offering faster performance for smaller datasets with higher memory usage.

If no group field is defined, both steps treat all rows as one group and return a single aggregated result.