Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Count with group by

gabrielf1
Level 2
Level 2

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

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

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

View solution in original post

1 Reply
ramon_bisswanger
Correct answer by
Employee
Employee

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

View solution in original post