Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Find and Replace

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

Highlighted
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
Highlighted
Meteoroid

Hey thanks for sharing this. It worked

Highlighted
Asteroid

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

Labels