Sum and Group

[JDong]

Hi All,

May be a trivial question

SlNo	Value	Value 2	Value3
2	3160	0
2	3500	3500	100

I want to sum Value field and group Value 2 how can I achieve this in Alteryx. Somehow in my flow does not work.

Output

SlNo	Value	Value 2	Value3
2	6600	3500	100

Thanks

[Jonathan-Sherman]

Hi @JDong,

Can you show the output table you're looking to achieve?

Regards,
Jonathan

[JDong]

@Jonathan-Sherman 

Please look at update in question 

[Jonathan-Sherman · Accepted solution]

Hi @JDong,

You could use the summarise tool for this:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[JDong]

I did use the summarize tool...but I had to trace back issue with 40 columns to see why the grouping was not happening 🙂

Is there any easy way to get over such grouping situations apart from removing and readding the columns in summarize tool to check ?

Thanks