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?
Solved! Go to Solution.
Just to be clear, it's the column header I'm trying to change.
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!
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 😀
Great, thanks Messi
That's Perfect! Thanks a lot for your help.