Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to remove underscore from multiply columns

Ro2
7 - Meteor

Hi,

I have an Alteryx output feeding into another Alteryx workflow. This output has 175 columns with _ underscore where I want to replace with a space.

For Example

Oct_Sales_Milk

I want this to read

Oct Sales Milk.

 

I could use the Select tool to rename the column however I'm not going to do this 175 times 🙂 

Up to now I have been downloading it to excel and using the replace function but the data is starting to get too big now to download to excel.

Any ideas?

9 REPLIES 9
Ro2
7 - Meteor

Just to be clear, it's the column header I'm trying to change.

atcodedog05
22 - Nova
22 - Nova

Hi @Ro2 

 

Use dynamic rename tool

 

I will give you an example.

messi007
15 - Aurora
15 - Aurora

Hi @Ro2,

 

Yes you can use the dynamic rename tool.

 

messi007_0-1604940161802.png

 

Attached the workflow, 

 

Please mark it as solved if it solve the problem 🙂

 

Many thanks!

atcodedog05
22 - Nova
22 - Nova

Hi @Ro2 

 

Here is a example

 

Input :

atcodedog05_0-1604940316704.png

Output:

atcodedog05_1-1604940337672.png

 

I am writing a replace function rename tool to replace _

atcodedog05_2-1604940382077.png

Happy to help 🙂

 

Cheers and Happy Analyzing 😀

atcodedog05
22 - Nova
22 - Nova

Hi @Ro2 

 

Here is a workflow with a guide for all the possible action.

atcodedog05_0-1604940476206.png

Hope this helps 🙂

Ro2
7 - Meteor

Great, thanks Messi

Ro2
7 - Meteor

That's Perfect! Thanks a lot for your help.

atcodedog05
22 - Nova
22 - Nova

Hi @Ro2 

 

If the posts helped can you please acknowledge by marking them as solution🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Ro2 

 

Cheers and Happy Analyzing 😀

Labels