# Group by-function script

**URL:** <https://forum.novacura.com/t/group-by-function-script/654>\
**Category:** Flow Classic\
**Tags:** studio-or-server\
**Created:** [April 8, 2024, 11:31am UTC](https://forum.novacura.com/t/group-by-function-script/654 "2024-04-08T11:31:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![knutivar.vestli](https://avatars.discourse-cdn.com/v4/letter/k/7C9FD7/32.png) [@knutivar.vestli](https://forum.novacura.com/u/knutivar.vestli)\
**Post date:** [April 8, 2024, 11:31am UTC](https://forum.novacura.com/t/group-by-function-script/654/1 "2024-04-08T11:31:38Z")

</div>

I would like to use Group by-function in a flow script, but Flow help doesn’t give me any help. I have a table variable, and would like to group a column in that table (named signed\_contracts).

I need to count fileId grouped by ContractNumber

table(fileId,  
fileName,  
title,  
contractNumber,  
contractType,  
formatSize,  
size,  
signatureDate,  
endDate,  
//userName,  
userEmail,  
//url,  
supplierCompanyName,  
companyRegistrationNumber);

---

<div class="post-metadata">

**Author:** ![ivstde](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/ivstde/32/146_2.png) [@ivstde](https://forum.novacura.com/u/ivstde)\
**Post date:** [April 8, 2024, 12:13pm UTC](https://forum.novacura.com/t/group-by-function-script/654/2 "2024-04-08T12:13:08Z")

</div>

Hi,

group by can be used to select from a previously defined flow table (similar to SQL).

This produces a new table with table(s) as column(s).

You can count how many rows that table column has (in the same scrip step, i just did it in an assignment so that it would show in debug)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/b73378dc54601359c75fe1b0c2a9270013020638.png)

Hope this helps!

B R  
Ivan

---

<div class="post-metadata">

**Author:** ![knutivar.vestli](https://avatars.discourse-cdn.com/v4/letter/k/7C9FD7/32.png) [@knutivar.vestli](https://forum.novacura.com/u/knutivar.vestli)\
**Post date:** [April 10, 2024, 1:03pm UTC](https://forum.novacura.com/t/group-by-function-script/654/3 "2024-04-10T13:03:01Z")

</div>

Thank you. That worked fine