How to Feed Summarize Tool dynamically?

Krzysiek

Hi

I am struggling with setting up Action to Summarize Tools connection.

How do I do it correctly to have outcome of Iterative macro set as Grouping factor in Summarize Tool?

So far I get there and cannot get rid of error at the above mentioned connection stage:

(The workflow shared is fed by dummy data)

Test.yxzp

Transformation

Interface Tools

Iterative Macro

Accepted answers

caltang

You will need to do some XML hacking to achieve your ask.

I wrote this some time ago: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Summarize-with-Interface-Tools/td-p/1160063

More reading here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Unknown-Select-Feature-w-Summarize-Tool/td-p/327371

In short, directly actioning your changes via interface to the Summarize tool doesn't work well since the selections are not active... by changing the XML directly, you are forcing the change and making it active.

apathetichell

@Krzysiek --- I've discussed this a few times here -- but I'd strongly recommend going for some combo of recordid/dynamic select/transpose instead of what you are doing --- short is dyanmic select selects only the fields you want --- transpose transposes everything but recordid. summarize does it's operations on recordid(group), and name doing whatever you want.

When changing the summarize tool via an action tool you must be incredibly careful with both the syntax of the operations and the fieldnames. If these are not correct --- you will break your workflow.

All comments

binu_acs

@Krzysiek, what are you trying to achieve with this macro? Can you provide more information for better understanding?

Krzysiek

Hey

I want to achieve multiple aggregation for list of all elements listed in the Input Tool.

The List would vary based on a trial, yet always there is expected same aggregation done by Summarize Tool for all listed Fields.

Say I am using Input with A, B, C Fields listed in its rows, and using the master file it supposed to be Pivoted to Group By A, B, C respectively and Counted no of those records, another time it could be different Fields