Collapsing similarly named/duplicate columns by summing values

Question

Hi all,

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

Input:

Output:

JosephSerpis · Accepted Answer

I've amended my workflow it uses regex to find the digit at the end of the column name.

RaviP · Accepted Answer

Hi @alpro-23,

If the column names are having numbers as suffix then you could also this