Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Summarize tool rename the column after the 2019.03 update

Kucsi
8 - Asteroid

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

14 REPLIES 14
davidhenington
9 - Comet

@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
9 - Comet

UPDATE: FIXED!!! 

 

NICE!!!

Kucsi
8 - Asteroid

Cool 🙂 Quite quick fix!

 

Thanks everyone! 🙂

akasubi
8 - Asteroid

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

ThizViz
11 - Bolide

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.

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Labels