Alteryx Designer Desktop Discussions

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

changing the field contents

jeetamar11
7 - Meteor

Hi,

 

I have some strings in the columns that I need to change to different strings.

Like in column-[Claims]- I have strings MP1, MP2, MP3 that needs to be replaced with word 'MOTO' and the words V13, V05, V19 needs to be replaced with word 'Keyed' and so on.

 

Please help!

3 REPLIES 3
cjaneczko
13 - Pulsar

The find and replace tool will work well here. Create a file or text input that has a list of all of the strings that need replacing. Then connect your Claims table and Text Input to a find and replace tool. 

jeetamar11
7 - Meteor

Can you elaborate that please. I never used Find and replace with a list

cjaneczko
13 - Pulsar

See attached workflow. You can also click on Examples under the Find and Replace tool within Alteryx to pull up sample workflows.

 

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels