Summarize tool rename the column after the 2019.03 update

Hi Community and admins,

After the latest update, there is a new feature in the summarize tool. Newly it is rename the column after group by. With the sum_ or max_ renameing it isn't any problem, but with this GroupBy_ renaming is very annoying. Mostly i have to group multiple columns, and after that join it to another line. Right now i have to delete manually the "GroupBy_" string (or when i have to update a previous workflow), and it takes a lot of time.

Is it possible to turn off this function?

Thanks in advance,

Kucsi

Workflow

Accepted answers

davidhenington

@mceleavey thanks for taking a stab at this. You got most of the way there!

Using dynamic rename, the formula you want to use is:

REGEX_Replace([_CurrentField_], 'Group By_','')

I can't believe we have to do this!!!

@Kucsi if you want to mark this as the solution that would be awesome!

All comments

mceleavey

Hi @Kucsi ,

I agree, and no, I don't think you can. However, it's probably quicker to apply a dynamic rename tool after the summarise tool and rename using a formula ( replace(_currentfields_,"Group by_","")

patrick_digan

@Kucsi Thanks for posting and alerting me to this issue with 2019.3!

mbarone

Yuk!

neilgallen

noticed it yesterday. Law of unintended consequences. I think on the surface it makes sense but in application (as mentioned above) it's a bit of mess. Would prefer it go back the other way!

Edit: have added this as a suggestion on the ideas page!

Kucsi

Hi,

thanks for the idea, i will use it in this case.

awhitacre77

I'd prefer if all renaming of fields in the summarize tool was optional, maybe similar to the select tool where you can highlight fields and select where to apply prefixes. I routinely find myself removing the prefixes (i.e. "Sum_") added to the Output Field Names. Sometimes the prefixes are helpful, but 90% of the time, I just want the original field names to carry through. This recent change when using GroupBy will force me to remove that prefix every time : (

davidhenington

omg this is annoying!

davidhenington

@mceleavey thanks for taking a stab at this. You got most of the way there!

Using dynamic rename, the formula you want to use is:

REGEX_Replace([_CurrentField_], 'Group By_','')

I can't believe we have to do this!!!

@Kucsi if you want to mark this as the solution that would be awesome!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703