Mass Find & Replace

[Faronnj]

Good Afternoon Alteryx Community,

First thank you, @fmvizcaino and @afv2688  for your help on my last problem and providing a workspace solution!  Your help has been extraordinary. 

I am excited to have yet another question to further our research with alteryx before my final meeting Wednesday.  I am looking for alteryx to look through all the preop through follow-up data and replace it with a certain value.  I will post the data and then I will post the conversions for the find and replace:

Last

Preop VA sc

Preop VA cc

BCVA

Postop VA > 1-3mo

> 4-12mo

> 1-2yrs

> 2-3yrs

> 3-5yrs

> 5-7yrs

> 7-9 yrs

> 10 yrs

UCVA @ Last F/U

1

F

FF

FFM

FF

FFM

FFM

2

FF

20/20

20/30

20/20

20/20

20/20

3

FF

20/40

20/30

20/20

20/20

20/20

4

FFM

2/500

FFM

FFM

5

FF(M)

FF

FFM

FFM

FFM

6

(F)

Poor F

BTL

FF

FF

FF(M)

FF(M)

7

(F)

Poor F

BTL

FF

(F)

FFM

FFM

8

F(F)

20/100

FF

20/30

20/30

20/25

FFM

20/30

9

BTL

20/100

BTL

BTL

20/40

20/100

FF(M)

20/125

10

CF @ 1ft

20/100

20/50

20/50

20/40

F(F)

F(F)

I would like alteryx to go through each column and find and replace with these values so i can achieve my final calculation:

Find	Replace
FFM	20/50
FF(M)	20/100
FF	20/150
F(F)	20/175
F	20/200
(F)	20/250
Poor F	20/300
CF @ 1ft	20/400
BTL	20/800

I would greatly appreciate if you would include a workspace since I believe this will be a rather complicated process.  I always am grateful for your workspaces since they help me learn as well as reduce the possibility of error when recreating.  Thank you again and look forward to your help,

Nick 

[fmvizcaino · Accepted solution]

Hi @Faronnj ,

I'm attaching a solution to your problem. The dynamic rename is being used to correct the column names.

Best,

Fernando Vizcaino

[afv2688 · Accepted solution]

Hello @Faronnj ,

Is this ok?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards