Grouping Data Multiple Based on Values from Two Columns

[Fescobar]

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

[AngelosPachis]

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

[atcodedog05]

Hi @Fescobar 

Input file and expected output seems to be the same whats the logic?

[Fescobar]

.@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.

[atcodedog05]

Hi @Fescobar 

Can you share an expected output.

[atcodedog05 · Accepted solution]

Hi @Fescobar 

Here is how you can do it.

Workflow:

Hope this helps : )

[Fescobar]

This is solution is so simple that its SEXY!  Thank you!!

Thank you .@atcodedog05! 

[atcodedog05]

Happy to help : ) @Fescobar 

Cheers and have a nice day!

[Fescobar]

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	Twitter	MAKER'S MARK
1	2021-05-01 14:00:00	TotalWine&More	American Whiskey	Facebook	JIM BEAM BRBN
2	2021-05-01 14:02:20	Drizly	Mezcal & Tequila	Instagram	PATRON
3	2021-05-01 14:19:41	TotalWine&More	American Whiskey	Instagram	N/A
3	2021-05-01 14:24:51	TotalWine&More	American Whiskey	Instagram	N/A
3	2021-05-01 15:00:00	BevMo!	Mezcal & Tequila	Twitter	N/A
3	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Twitter	N/A
3	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Twitter	N/A
3	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Facebook	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	Twitter	MAKER'S MARK
2	2021-05-01 14:00:00	TotalWine&More	American Whiskey	Facebook	JIM BEAM BRBN
3	2021-05-01 14:02:20	Drizly	Mezcal & Tequila	Instagram	PATRON
4	2021-05-01 14:19:41	TotalWine&More	American Whiskey	Instagram	N/A
5	2021-05-01 14:24:51	TotalWine&More	American Whiskey	Instagram	N/A
6	2021-05-01 15:00:00	BevMo!	Mezcal & Tequila	Twitter	N/A
7	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Twitter	N/A
7	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Twitter	N/A
7	2021-05-01 15:00:00	Spec'sWinesSpiritsandFinerFoods	Mezcal & Tequila	Facebook	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