cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

Conditional sum of columns

Hi guys, (Updated the post sorry wasnt clear earlier)

 

I have a table below above is the table i have below is what i want using alteryx can anyone help?

 

Input         
cidmoPCIDPIDcount 1count 2zipSTPname 
121028201404114932849426301.0321001MAs 
12102820140411493284942643.1265.1861001MAs 
11953320140411493284942651.0451.0451001MAf 
11953320140411493284942661.0481.0481001MAf 
Output         
cidmoPCIDcount 1_scount 2_scount 1_fcount 2_fzipSTPname
12102820140411493283.1266.218001001MAs
1195332014041149328002.0932.0931001MAf
Alteryx Certified Partner
Alteryx Certified Partner

You are looking for the Summarize tool using Group By on [id]

 

Screen Shot 2016-05-24 at 10.36.06 AM.png

 

Click the Open Example link in the tool summary to see examples of how to use the tool.

 

Alteryx Alumni (Retired)

@michael_treadwell has pointed you to the correct tool. Not sure I understand what is conditional about the process.

Looks like you are just summing the two count columns and grouping by everything else but the PID column?

Alteryx Certified Partner
Alteryx Certified Partner

@akshatkumar87

 

If you want to peek at a working model to help you further, the answer is in my attachment.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Hey Michael,

 

Its not simple summarize as i am adding sum columns for every product

for ex sum_f is for all the rows matching product f and so on..so grouping by id will give me overall sum not the product wise summation

 

Thank you

Its not simple summarize as i am adding sum columns for every product

for ex sum_f is for all the rows matching product f and so on..so grouping by id will give me overall sum not the product wise summation

 

Thank you

cannot open your workflow apparently its on the newest version

Alteryx Certified Partner
Alteryx Certified Partner
Open with notepad and you can edit 10.5 and make it 10.0. After you save it will open.

Sent from my iPhone
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Alteryx Certified Partner
Alteryx Certified Partner

You should be able to open this yxmd workflow.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Hey Marquee,

 

The file worked but that is not the solution i am looking for. The idea is to get column for every product and sum it. Check the updated output above.

 

Thank you