Adding based on dynamic number of columns

[SDeora]

Hi,

My data contains columns which are selected based on a dynamic input. There is a set of constant columns and then there are columns starting with a set of specific characters like "ABC" everytime (ABC01/AB02/AB03... ABC12).

Everytime the workflow runs it will have a different number of the "ABC" columns. I need a new column which will have the total of all values in "ABC" columns regardless of how many there are. 

I've attached examples of the data for your reference. Please help!! 

[DanielG]

Unless I am misunderstanding, can't you transpose the data, filter on the left 3 characters being ABC, then summarize them and you will have total of all ABC columns for use in other parts of your workflow.

Sorry.  Dont have access to Alteryx right now to build sample.

[SDeora]

Sorry... I need the total of values in the "ABC" columns and not the count. 

[DanielG]

Sorry I wasnt clearer.

I think I was too general in my comment.

Use the summarize tool and select "SUM" as the action and it will sum them up.

[RolandSchubert · Accepted solution]

Hi @SDeora ,

I assume, in your sample you want to dd the columns starting with "HSL". I think, you could transpose columns to rows, use a filter tool to select the columns starting with the specified string, summarize these columns (now rows) and join them to your original data. I attached a sample workflow. What do you think?

Best,

Roland 

[SDeora]

Great!! thanks! 

[DanielG · Accepted solution]

@RolandSchubert 

Thanks for posting a sample.  I was unable to when I explained the process earlier.

[SF_]

Hi,

I have a similar problem but it's months in the columns and I want to sum YTD as Jan-Jun (as Jul-Dec is not available) but I want this to be dynamic. How can I then modify the workflow to accommodate this ?