Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Compare one row to all other rows

7 - Meteor

Hi All, 


I have a set of data that has multiple rows with the same date. Is there a tool that could compare one row to every single row in the data set? Ideally, I would add the data associated with that date and create a new 'totals' column. I have attached a picture of what the data looks like right now below and would love to be able to add all 2020-07-18 data points together for example. 


Thank you! 


16 - Nebula

I would play around with the summarize tool - group by date and look at the other options available. Add any other columns you need, then join back to the original date set.

Alteryx Certified Partner



the Summarize tool will give you the totals per date. You can then join those totals to the original data and have a totals column if that's what you want to do.




If this works for you, please mark it as a solution. If not, please explain how it faltered and also provide data in a file not a photo.



7 - Meteor

Thank you so much for your help! That worked perfectly.