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.
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.