Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Filter based on summed column

TJ2
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?

7 REPLIES 7
grossal
15 - Aurora
15 - Aurora

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

TJ2
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.

grossal
15 - Aurora
15 - Aurora

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

 

 

TJ2
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.

 

grossal
15 - Aurora
15 - Aurora

Ahh, I think I finally got what you want.

 

grossal_0-1586545082591.png

 

Output:

grossal_1-1586545092722.png

 

Updated workflow attached.

 

Best

Alex

TJ2
7 - Meteor

That's it. Thanks!

 

grossal
15 - Aurora
15 - Aurora

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

Labels