Designer | Group duplicates and how count them
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What would the workflow be like?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AlejandroGomezMerida - I used some sample data for this example, you can replace with your data.
