changing the field contents

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!

Datasets

Data Investigation

Accepted answers

cjaneczko

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

Find and Replace.yxmd

All comments

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

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

Find and Replace.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703