community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Changing Column Names Using Summarize Tool

Atom

I'm attempting to use the Summarize tool to sum the contents of a range of columns each week. Goal: I want to be able to just insert the second data set and not have to edit the workflow to reflect the change in column names or change in number of columns form the first data set. 

 

For Example: 

Data Input 1

Red Blue Green
1019
12212
14315

I'd then Go to the Summary tool and go 'Sum' for Red, Blue and Green. 

Data Input 2

YellowPinkPurpleBlackBrown
281324
371324

Now if I insert this data input and hit run I get and error in my Summarize tool. 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @born I mocked up a approach that might solve your issue let me know what you think?

 

Summarise061119.PNG

Atom

That solution works for the Dummy Data I drew up. However I have another field in the first column that lists names to the respective values in each column. 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @born can you provide that extra column?

Atom

The data would look like the input chart. The output I want is below it. Where it is to be grouped by name and the sum of fruit category. And I can build an alteryx that does this if the fruits stay the same, but I need to build something that is dynamic and will work for any number / name of fruits. 

Labels