Summarize tool rename the column after the 2019.03 update

[Kucsi]

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

[davidhenington · Accepted solution]

@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! 

[davidhenington]

UPDATE: FIXED!!! 

NICE!!!

[Kucsi]

Cool 🙂 Quite quick fix!

Thanks everyone! 🙂

[akasubi]

Thanks for the suggestion. Do you know if someone similar is possible using the in-DB tools?

[ThizViz]

I was just wondering the exact same thing. The only thing I've found that is quicker than manual rename is to copy the XML to text and do a find/replace, then paste it back in. It's a royal pain still.

[MackStewart]

Thank you for the point in the right direction. It made me go check it out.

There is no need to copy the XML to a text editor. There is one built in. 🏆

I have made a tiny ppt with screenshots.