Designer | Group duplicates and how count them

[AlejandroGomezMerida]

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

[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 · Accepted solution]

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

Spoiler