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?

Dynamic Summary tool POC Help

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.

Untitled picture doubt.png

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

Untitled picture doubt1 .png

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?

Transformation

Accepted answers

cpet13

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)

binu_acs

@Jules22 Attaching the sample workflow

DynamicSummarize_01022025.yxzp

All comments

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

Jules22

Can you demonstrate a small poc?

binu_acs

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

Jules22

hi @binu_acs, please refer below

binu_acs

@Jules22 Attaching the sample workflow

DynamicSummarize_01022025.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703