Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to group to sum data and remove duplicated rows?

LeiCheng
8 - Asteroid

 

It looks easy, but I really don't know how to deal with this. first sum the IDs hrs, then remove duplicated date....

group sum.jpg

 

2 REPLIES 2
JoshuaGostick
11 - Bolide

Hi @LeiCheng,

 

The workflow attached should do the trick for you. Let me know if you have any questions about it.

 

Thanks,

Josh

Dazzerman
11 - Bolide

Hi LeiCheng,

 

Here is a solution to your problem.

 

I hope this helps!

 

LeiCheng_query.jpg

Labels