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.
Solved! Go to 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?
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
Thank you both for your solutions. Always more than one way to skin a cat especially with Alteryx!