Grouping Data Multiple Based on Values from Two Columns

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

Pulse Sample.yxmd

Actual Results.png

Expected-Required Results.png

Pulse_Sample.xlsx

Datasets

Transformation

Preparation

Data Investigation

Accepted answers

atcodedog05

Hi @Fescobar

Here is how you can do it.

Workflow:

Hope this helps : )

Pulse Sample.yxmd

All comments

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.

Pulse_Sample.xlsx

atcodedog05

Hi @Fescobar

Can you share an expected output.

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703