This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Data Input 1
I'd then Go to the Summary tool and go 'Sum' for Red, Blue and Green.
Data Input 2
Now if I insert this data input and hit run I get and error in my Summarize tool.
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.