changing the field contents

[jeetamar11]

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!

[cjaneczko]

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]

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

[cjaneczko · Accepted solution]

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