How to remove underscore from multiply columns

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?

Best Practices

Accepted answers

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!

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

All comments

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

Use dynamic rename tool

I will give you an example.

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!

Great, thanks Messi

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703