Summing up the data based on condition

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

Input

Accepted answers

atcodedog05

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 😀👍

quantity (1).yxmd

All comments

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 😀👍

quantity.yxmd

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.

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

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 😀👍

quantity (1).yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335