Dynamic Summary tool POC Help

[Jules22]

I've defined some values using a formula tool on the "Days Pending(Prop)" column and output them into an "Aging Bucket" column. I've hardcoded five values, with others set to NA.

Later, I use a cross-tab tool to convert these values into columns and then apply a summary tool.

The issue is that the "Days Pending(Prop)" column doesn't always contain the five hardcoded values. I need the summary tool to be dynamic, adapting to the available data.

Is it possible to achieve this? Could you demonstrate a proof of concept?

[OTrieger]

@Jules22 
It is possible to make it dynamic however that would be a more complex solution. What you can do ensure that you always going to have all the 5 elements and if one is not reported then have zeros for that element.

[OTrieger]

If you want to do it fully dynamic, you can do it by changing the XML data for the Summarize tool, sending it into a Batch Macro and update the XML to the available fields. So yes, it is possible.

[cpet13 · Accepted solution]

Hi @Jules22. This may be a scenario for you to create a batch macro. Check out this article to find out more about batch macros and how they might help. Getting Started with Batch Macros (alteryx.com)

[Jules22]

Can you demonstrate a small poc?

[binuacs]

@Jules22 can you post some sample data which is generated by the cross tab tool 

[Jules22]

hi @binuacs, please refer below

[binuacs · Accepted solution]

@Jules22 Attaching the sample workflow