community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Find and Replace

Highlighted
Meteoroid

Hi,

 I want to replace the whole string (in my Source table field) with the value from lookup table(target). For Ex: SourceField('xxx123') Target(123). If any part of the SourceField contains '123', I want to replace value '123' from Target  into SourceField.   My lookup table has 60 values. So I don't want to hard code using IF THEN ELSIF condition. Is there any way or tool to do this in Alteryx

Nebula
Nebula
There is a quick way round this - use the find-replace tool but instead of replacing instances of the search pattern, chose the option to append a field with the replacement text.

You can then do a quick formula to replace your original field with this new
Column if it is not null.

Let me know if this solves your problem (and would you mind marking as solved) or if you still have questions reply on this thread with sample data and I can mock it up for you tonight.

Cheers
Sean
Meteoroid

Hey thanks for sharing this. It worked

Asteroid

Hi,  Could you explain how to use the lookup values in the formula?

Labels