Multirow Tool

BarleyCorn

Hi Alteryx brothers and sisters, 

Hopefully an easy one here?

In attached excel, I would like to add row values together if they are on the same day and are the same names.

So, Column one "Campaign" and "Datetime" column - add Impressions and clicks into one datetime row if Campaign = Vhi Life.

So rows 2 to 6 in attached excel becomes one row for 04 May 2016 with Impressions = 80 and clicks = 37.

Or something close to this?

Thanks

BCAlteryxMultiRowQ.xlsx

patrick_digan

@BarleyCorn Would the summarize tool get you everything you need? I've attached a quick workflow. Let me know if it's missing something.

Community_Summarize.yxmd