This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com
I am completely new to Alteryx and I am trying to do a workflow that can collapse all similarly named columns by summing the values within the column. My values currently are dummy variables hence all in 0 / 1.
Thus far, I can't find any similar posts on Alteryx regarding similarly named columns and summing values.
Would appreciate help from anyone on this topic!
** In my actual workflow, I have more than 100 columns that faces this issue... hence I chose not to do this manually (ie. typing 'pool' and 'roof') in my workflow. Any way to automate this?**
Hi @alpro-23 I mocked up an approach to tackle this challenge. The approach essentially pivots your data and then uses the text to column tool to split your fields based on _ and then aggregates the data and pivots back to a horizontal format. Let me know what you think?