Grouping Data Multiple Based on Values from Two Columns
- 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
Hello Community,
I hope that you're all doing well and if you're in the US that you had a wonderful/safe Labor Day Weekend.
I am trying to group some data I scraped into groups by Date and Retailer; however, when I use the Summarize tool to group, it only returns the two columns I selected to group by.
I am attaching the sample data as well as the very simple workflow I am attempting to use with the Summarize too. In addition I am also attaching the results I am seeing with the attached workflow and what I need/expect my results be returned as.
As always...THANK YOU!!
Fausto
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Fescobar ,
Not sire if your expected results screenshot is the one you meant to upload. It seems to me that it's a screenshot of the Pulse_Sample.xlsx file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
.@atcodedog05 and .@AngelosPachis
Yes, I am sorry. My expected results would be to have each entry grouped by a number IF the date and retailer match...like in the screenshot. I have updated the sample file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Fescobar
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi .@atcodedog05,
I hope that you're doing well.
The requirement on the solution you provided changed a bit. I have been trying to make changes to the Multi Row formula on my own, but nothing I am doing is proving the results I need.
The question is, what would be the expression if I wanted to group and create a Pulse Promo for three different fields.
For example I am replacing the expression you provided
IF [Retailer / Website]!=[Row-1:Retailer / Website]
THEN [Row-1:Pulse Group]+1 ELSE [Row-1:Pulse Group] ENDIF
To
IF [Channel] and [Retailer / Website] and [Date]!=[Row-1:Channel]
THEN [Row-1:Pulse Group]+1 ELSE [Row-1:Pulse Group] ENDIF (This did not return anything)
I also tried
IF [Brand Family]!=[Row-1:Brand Family]
THEN [Row-1:Pulse Group]+1 ELSE [Row-1:Pulse Group] ENDIF (This returned the result below)
I tried these and others in hopes that it will create a "pulse group" when Date, Retailer, and Channel are the same. If there's a change, then a new "pulse group" is created.
Pulse Group | Date | [Retailer / Website | Spirits Category | Channel | Brand Family |
1 | 2021-05-01 13:00:00 | TotalWine&More | American Whiskey | MAKER'S MARK | |
1 | 2021-05-01 14:00:00 | TotalWine&More | American Whiskey | JIM BEAM BRBN | |
2 | 2021-05-01 14:02:20 | Drizly | Mezcal & Tequila | PATRON | |
3 | 2021-05-01 14:19:41 | TotalWine&More | American Whiskey | N/A | |
3 | 2021-05-01 14:24:51 | TotalWine&More | American Whiskey | N/A | |
3 | 2021-05-01 15:00:00 | BevMo! | Mezcal & Tequila | N/A | |
3 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A | |
3 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A | |
3 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A |
What I was expecting to see in all of my attempts was this.
Pulse Group | Date | [Retailer / Website | Spirits Category | Channel | Brand Family |
1 | 2021-05-01 13:00:00 | TotalWine&More | American Whiskey | MAKER'S MARK | |
2 | 2021-05-01 14:00:00 | TotalWine&More | American Whiskey | JIM BEAM BRBN | |
3 | 2021-05-01 14:02:20 | Drizly | Mezcal & Tequila | PATRON | |
4 | 2021-05-01 14:19:41 | TotalWine&More | American Whiskey | N/A | |
5 | 2021-05-01 14:24:51 | TotalWine&More | American Whiskey | N/A | |
6 | 2021-05-01 15:00:00 | BevMo! | Mezcal & Tequila | N/A | |
7 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A | |
7 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A | |
7 | 2021-05-01 15:00:00 | Spec'sWinesSpiritsandFinerFoods | Mezcal & Tequila | N/A |
What would I need to change the expression to in order to achieve this? Is this even possible with the Multi Row Formula?
Thank you for your assistance in advance!
Fausto