In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Replace - Newby warning!

MaryCann
8 - Asteroid

Hello everyone.  Warning:  I am super new at Alteryx, so, if you reply, I kinda need detailed how-to stuff.  Okay, so, I have this column called "person hist baseline", unfortunately in this column "Caridovascular" is listed, not "Cardiovascular".  I'm guessing I need a Formula, with the Output Column on "person hist baseline" but, my Replace formula did not work.  Like I said, I'm new to this, so, probably did something wrong.  And, of course, I don't want to bug my boss for help - just call me stubborn.  How should the Replace formula be structured?

 

Thank you in advance!!  :)

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @MaryCann 

 

Both words look same to me 🤔 Also can you show what you are doing.

 

Happy to help : )

MaryCann
8 - Asteroid

MaryCann_0-1643906273630.png

Wow!  Superfast response!  Here's what I'm trying to do... (cool, I also just figured out how to paste a snip too!)

binu_acs
21 - Polaris

@MaryCann IF you have more words to replace please go with the Find and Replace tool

 

binuacs_0-1643908866746.png

 

Formula for replacing the string

 

binuacs_1-1643909178705.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @MaryCann 

 

You need to provide input column name first like below

 

atcodedog05_0-1643909053663.png

 

Hope this helps : )

 

MaryCann
8 - Asteroid

WAHOO!!!!  You folks are awesome!!!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @MaryCann 

If my response helps please don't forget to mark it as solution.

 

Also here are some great resources to get started https://community.alteryx.com/t5/Learning-Paths/tkb-p/learning-path 

 

All the best in the journey 🙂

Cheers and have a nice day!

alteryxnewby
5 - Atom

.

Labels
Top Solution Authors