Deleting "Sum_" in Header Output Field Name after Summarize

[JSnyder]

Is there a simple way to remove the "Sum_" in the Output Field Name after Summarizing?

I'm working with monthly information for multiple years and am currently just Finding and Replacing "Sum_" with "" in excel after running my workflow, because it is much faster than renaming in Alteryx.

I know you can "Replace" using the Formula tool, but I would have to do this for every column, since it's the header name.

Thanks,

[JosephSerpis]

Hi @JSnyder you can use a dynamic rename tool and select remove prefix and specify Sum_ for all columns after the summarize tool.

[NicholasM]

Hey @JSnyder 

You could try using the Dynamic Rename tool, utilizing the option Remove Prefix/Suffix. This will scan all column headers and replace all that contain "Sum_" with one tool. 

Just make sure all the columns are checked in boxes at the top of the configuration window. 

[danilang]

Hi @JSnyder 

You can also change the output field name in the summarize tool

 

[grodge13]

You can do this quickly and easily using a select tool after your summarize tool. Just highlight the columns that you want to change, go to Options and select Remove Prefix. 

[NathanOch]

I was wondering if there was a possibility of using a wildcard in the dynamic rename tool? I have some SOQL results where the child records returns the object name and record sequence as a prefix. For instance, I will see a field name LASERCA__Personal_Credit_Reports__r.records.0.LASERCA__Credit_Score__c and then a different field name LASERCA__Personal_Credit_Reports__r.records.1.LASERCA__Credit_Score__c. I'd love to get rid of the prefix 'LASERCA__Personal_Credit_Reports__r.records.X.' altogether with the X being a wildcard.