community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Summarize Tool / Formula Tool

Meteoroid

I Have a input data, if a sum of particular reference nets to zero then that line i wanted to exclude to proceed further steps. Can i use summarize or which tool would be ideal for removing sum of a reference with nets to zero.   

 

i have attached the workflow, if the sum of PO column is nets to zero then i want it be removed from the output.  can anyone advice me ASAP I have a project to be submitted tomorrow.

Thanks a lot for your help in advance.

Alteryx Partner
Alteryx Partner

Hi @phemala1 ,

 

this workflow eliminates the colums which have sum = 0

 

cheers

Meteoroid

Thanks for your response, I will try this and comment. Thanks:)

Meteoroid

i want the entire row to be eliminated if two are many row put together nets to zero, will this work out with the above work flow you have provided (eliminate column).

Alteryx Partner
Alteryx Partner

Hi @phemala1 ,

 

I'm sorry I cant get what you mean. Could you please create a dummy input and output on a table here to illustrate your needs?

 

Cheers

Meteoroid

i have attached the excel, i have PO_ID in column I and value in column AA. There will be a positive line in a row for the PO_ID and negative line in another, if the sum of PO_ID nets to zero then both the rows (positive and negative) has to be removed from the output.

 

In the attached excel first two rows has this case, Kindly advice. 

Highlighted
Alteryx Partner
Alteryx Partner

Hi @phemala1 ,

 

I think I managed to do what you asked me to using your file.

 

cheers

Labels