Designer | Group duplicates and how count them

Good morning, I have a question that I cannot resolve. I want to join 4 equal rows in a single line and that a new column called "Count" is created for me that tells me how many repeated values have been grouped. I show an example.

What i have.

Need this.

Thank you very much

Help

Accepted answers

binu_acs

@AlejandroGomezMerida - I used some sample data for this example, you can replace with your data.

Spoiler

SmartTile.yxmd

All comments

AngelosPachis

Hi @AlejandroGomezMerida ,

Try to use a summarise tool, group on all your columns except [No doc] and [Count]. Then select the [No doc] columns and add an action to keep the Last value. Finally, select the [No Doc] column again and select to add an action to CountDistinct values, which will serve as your new Count column

Hope that helps,

Angelos

AlejandroGomezMerida

What would the workflow be like?

binu_acs

@AlejandroGomezMerida - I used some sample data for this example, you can replace with your data.

Spoiler

SmartTile.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335