Adding based on dynamic number of columns

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!!

Data.yxmd

Dynamic Processing

Accepted answers

RolandSchubert

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

Data.yxmd

DanielG

@RolandSchubert

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

All comments

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.

RolandSchubert

Hi @SDeora ,

Best,

Roland

Data.yxmd

SDeora

Great!! thanks!

DanielG

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703