Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Filter based on summed column

Highlighted
7 - Meteor

I'm trying to filter data based on if a summed amount from the table results the net remaining not equaling zero.

 

TJ2_0-1586541186828.png

 

I need the data related to Category B,C & G to be eliminated from the workflow. 

Any suggestions?

Highlighted
14 - Magnetar

Hi @TJ2,

 

you could achieve this using a Filter Tool:

 

grossal_0-1586541621804.png

 

Input:

grossal_1-1586541636353.png

 

Setting:

grossal_2-1586541648645.png

 

Output:

grossal_3-1586541661454.png

 

Sample workflow attached.

 

Best

Alex

Highlighted
7 - Meteor

Another point, the summarized data represents the sum of >1000 rows of data. So I need to remove all records from the workflow in which the summed total of the same category equals zero.

Highlighted
14 - Magnetar

Oh sorry, your sample did not provide multiple appearances of the same category, therefore I assumed you already summed it up.

 

I adapted the case:

grossal_1-1586542690384.png

 

 

Input:

 

grossal_0-1586542681639.png

 

Summed up:

 

grossal_2-1586542708433.png

 

Filtered (T-Anker):

 

grossal_4-1586542751539.png

 

 

Updated workflow attached. Is that what you are looking for?

 

Best

Alex

 

 

Highlighted
7 - Meteor

I think it's getting close. The summarize tool can identify what categories totals to zero, however I need all of the unsummarized data (all the other fields in the table) to process further in the workflow.

 

So my table contains >1M records. I only want to pass through all of the records where the sum total of the categories are not zero. So using your example only want all of the records for Categories A,C,D. to remain because the sum of all the records do not equal zero.

 

Highlighted
14 - Magnetar

Ahh, I think I finally got what you want.

 

grossal_0-1586545082591.png

 

Output:

grossal_1-1586545092722.png

 

Updated workflow attached.

 

Best

Alex

Highlighted
7 - Meteor

That's it. Thanks!

 

Highlighted
14 - Magnetar

Sorry that it took so long, my brain slows down in the evening :')

Labels