Alteryx macro dynamic Summarize tool

[DE22]

Hello, 

Could you, please help me with the topic below?

I need to select a column, based on the previous year for which i run the flow, and that column should be taken by Summarize tool. It should be like a macro, in which you can see all the columns and you can select the one you want to summarized. 

Thank you!

I attached the sample workflow!

Thank you!

Input:

Contract	Emmision 2023	Emmision 2024	Emmision 2050
edeneja4391	548958	473849	48594
canejkdn88	34794	345566	57485

Summarize Output:

Contract	Group By	Contract
Emmision 2024	Sum	Sum_Emmision 2024

[mceleavey · Accepted solution]

Hi @DE22 ,

I've attached a workflow that will dynamically select the fields associated to the previous year, which is also automatically determined.

The workflow calculates the previous year using the following formula:

DateTimeYear(datetimetoday())-1

It then groups this into the control parameter before feeding into the batch macro:

The batch macro pivots the data, filters the data to those rows containing the previous year, then pivots back using the SUM aggregation function.

This gives the following:

I've attached the packaged workflow. I hope this helps.

M.

[DE22]

Thank you very much for your great work! It works very good :) 😍