Group by-function script

Flow Classic
1

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);

2

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
image1505×984 61.5 KB

Hope this helps!

B R
Ivan

3

Thank you. That worked fine