How to remove underscore from multiply columns

[Ro2]

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?

[Ro2]

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

[atcodedog05]

Hi @Ro2 

Use dynamic rename tool

I will give you an example.

[messi007 · Accepted solution]

Hi @Ro2,

Yes you can use the dynamic rename tool.

Attached the workflow, 

Please mark it as solved if it solve the problem 🙂

Many thanks!

[atcodedog05]

Hi @Ro2 

Here is a example

Input :

Output:

I am writing a replace function rename tool to replace _

Happy to help 🙂

Cheers and Happy Analyzing 😀

[atcodedog05]

Hi @Ro2 

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

Hope this helps 🙂

[Ro2]

Great, thanks Messi

[Ro2]

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

[atcodedog05 · Accepted solution]

Hi @Ro2 

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

[atcodedog05]

Happy to help 🙂 @Ro2 

Cheers and Happy Analyzing 😀