In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Attempting to sum Multiple Columns that meet a certain criteria (dynamic)

tommyjohn342
5 - Atom
Prod #DescriptionCGTotals5 SHP5 MMS5 Other12 SHP12 MMS12 Other14 SHP14 MMS14 Other
1Apple4829115  65  844879
2Orange 48841 546514 8448  
3Pear482135  51518  98
4Banana48597 45 51 8 4849
5Pineapple4813745  8 84   
6Grapes48101  14  48 48

 

I need help trying to combine columns that start with the same number (store number) into a single column.

 

For example. What is the sum of Orange for Store 5 (5 SHP + 5 MMS + 5 Other) ? 

 

Please note:

This has to be dynamic in the sense that I don't know what other stores will be added or taken away but the format will not change.

 

So if a store 16 shows up i know it will come in 3 columns and be laid out like (16 SHP, 16 MMS, 16 Other). I am just looking for a way to combine each column that is split into 3 columns currently so that the output is 1 single column with the sum of all 3 columns.

 

Please help me! I am very new to Alteryx. 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@tommyjohn342 

This is for sure dynamic

0128-tommyjohn342.PNG

tommyjohn342
5 - Atom

Thanks for taking the time to reply! This is where I was stuck as well. 

 

Qiu
21 - Polaris
21 - Polaris

@tommyjohn342 

Glad to help and thank you for the accept mark!

Labels
Top Solution Authors