Summing up the data based on condition

[Nikhil86]

Hi folks, 

I am sort of struggling to get over this problem I am beginner to Alteryx : I have a spreadsheet which contains UniqueIDs as seen below: I would like to put a condition within Alteryx if ABC123 contains more then once it should add the Quantity against it . Which tool can i use to handle such situation? 

expected output should be : ABC123 = 30

[atcodedog05]

Hi @Nikhil86 

You can use summarize tool

Grouby ID and sum Quantity

Config:

[atcodedog05]

Hi @Nikhil86 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Nikhil86]

@atcodedog05 , 

Thanks for this , it has resolved my issue partially however I have different fields which I would like to carry forward from Input (Date, Requester , Department) The summarize tool will just provide 2 fields UniqueID and Quantity . I was thinking more to use a formula tool to retain all the fields  

[atcodedog05]

Hi @Nikhil86 

For a single unique ID you have multiple different Dates what do you want to do about it after grouby and reducing 3 rows to 1 row.

Can you give me an expected output.

[atcodedog05]

Hi @Nikhil86 

Is this what you are looking for

[Nikhil86]

@atcodedog05 , 

Apologies , I did not notice in my dummy date I left the date part: Below is what i am trying to achieve: Dates will be same for the UniqueID in my scenario . Appreciate your feedback and help  

The output should net based on similar 'UniqueID' and Sum up the 'Quantity', assuming data wont change at all. 

[atcodedog05 · Accepted solution]

Hi @Nikhil86 

You can configure the sumaarize tool like below.

Output

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂

Cheers and Happy Analyzing 😀