Dynamic Summarize

Question

Hello

Hi, I have specified a range for a data where the columns keep on changing everyday based on  hours team worked  and we use "Summarize" tool, 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 column consist of hours coulmn name like 2am, 10am , 2pm  and so on. while sometimes 1Am 11am, 12pm . So the column  name changes and may not repeat next day This changes catches error in summarize tool and would like have it ignored every time there are changes in the coulmn. Is there any way to do it dynamically in the Summarize tool

cjaneczko · Accepted Answer

I think what you may have to do is Dynamically rename the columns using a RecordID so the columns are always 1 - n. Then once you are done with them in the summarize tool, dynamically rename them back to what they were. I have to do this with columns as months roll. Because the data always ends up shifting on me month after month and is never the same. This eliminated that problem.