Alteryx Designer Discussions

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

Find and Replace within a row

StefanvanWyk
7 - Meteor

Good Day,

 

The solution to this might be very simple. However, I have looked at a couple of options and could not find one.

 

I need to find a certain word within my table rows and replace it. What would be the best way to go about this?

 

9 REPLIES 9
atcodedog05
21 - Polaris

Hi @StefanvanWyk 

 

Can you provide some sample data and expected output. So that we can help you out better 🙂

StefanvanWyk
7 - Meteor

Sure, thank you.

 

I have attached a simplified version of the sample data.

 

Basically, we have datasets containing all our businesses. However, we changed the name of the business. Now for comparable figures, we need to change all the previous records from the old name to the new business name.

 

Within the Sample Data, the one that I am trying to change is Roto N to N Labels.

atcodedog05
21 - Polaris

Hi @StefanvanWyk 

 

You can do something like this.

 

Input:

atcodedog05_0-1603952860722.png

Reference containing changes

atcodedog05_1-1603952889342.png

Output:

atcodedog05_2-1603952919886.png

Workflow:

atcodedog05_3-1603952937089.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

 

Qiu
18 - Pollux

@StefanvanWyk 
There are a couple of ways, but I prefer the Find and Replace Tool considering you may have more that one to find and replace.
Appreciate you would mark it as accepted if you find it works for you.FindandReplace Sample Data.PNG

StefanvanWyk
7 - Meteor

Thank you so much for the assistance.

 

It worked!😊

Qiu
18 - Pollux

@atcodedog05 
You are too fast!

atcodedog05
21 - Polaris

Happy to help 🙂 @StefanvanWyk 

 

Cheers and Happy Analyzing 😀

Qiu
18 - Pollux

@StefanvanWyk 
Warm note, multiple accept is allowed here😁

Qiu
18 - Pollux

@StefanvanWyk 
thank you so much!

Labels