Fix Missing Field in Summarize Tool

Hi Guys,

Just like to ask if there is a way we could ignore the missing fields in summarize tool. I have a data that change every time I run. My field consist of number of days whose field name like 0, 1 , 2, 3 and so on. Sometimes the data would include field name 2, 3, 5 and 10 while sometimes 10, 11, 12, 15. So the filed name changes. This changes catches error in summarize tool and would like have it ignored every time there are changes in the field name. I hope you could help me find a way.

Thanks,

Marl

Output

Tips and Tricks

Common Use Cases

Accepted answers

All comments

binu_acs

@KamenRider can you provide some sample data

KamenRider

Hi @binu_acs, please see below my screenshots I made using excel file. This is my workflow with error under summary tool.

This is my sample output

Below is the configuration from my summary tool that has error. As request, is it possible to bypass or ignore the error since the field name (numbers) changes everyday.

Hoping for your response and assistance. Thank you so much

Mar

KamenRider

Hi Guys,

Anyone for your assistance please.

Thanks

apathetichell

There are ways to make a dynamic summarize tool (they involve complicated batch macros and dynamic select) but honestly - you can probably do whatever you want by using a transpose tool. You want your potential summarize columns in the name field and your potential values in value and then you group and sum.