Count with group by | Community
Skip to main content
G
gabrielf1
Level 2
June 11, 2020
Solved

Count with group by

  • June 11, 2020
  • 1 reply
  • 2712 views

Hello,

 

Please, could you help me? How can I count the number of rows with a group by? I tried RowNum(PartitionBy(@IdCliente), OrderBy(@IdCliente)) but it doesn't works.

 

Att.,

Gabriel

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

Hi Gabriel,

 

yes the RowNum would be the correct approach.

The item you want to group by is the column mentioned in PartitionBy.

i.e. for you it would count the row number per IdClient.

 

Note: the result will contain all rows still.

To keep only the highest number, you need to add a deduplication task, choose Expression as method, choose the calculated field containig the row number and choose to keep the highest value

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
June 11, 2020

Hi Gabriel,

 

yes the RowNum would be the correct approach.

The item you want to group by is the column mentioned in PartitionBy.

i.e. for you it would count the row number per IdClient.

 

Note: the result will contain all rows still.

To keep only the highest number, you need to add a deduplication task, choose Expression as method, choose the calculated field containig the row number and choose to keep the highest value

    Terms & ConditionsAccessibility statement

    Loading footer...