Dynamic Select: Exclude column if sum = 0

[bertal34]

I want to exclude a particular column (call it Col_C) if it's sum = 0 (zero).  Allow all other columns to continue through the workflow.  I believe this is possible using Dynamic Select but cannot figure it out.

[JosephSerpis · Accepted solution]

Hi @bertal34 think you would need to use a summarise tool to see if a column = 0. I've mocked up a workflow that filter out if a column = 0. Let me know what you think?

[GiuseppeC]

Hi @bertal34,

a different approach, using the macro shared on this post: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Add-List-Based-Mode-to-Dynamic-Select/idi-p/...

Workflow attached.

Hope it helps!

Giuseppe

[bertal34]

Thank you both for your solutions.  Always more than one way to skin a cat especially with Alteryx!