Alteryx Contains Function Question
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AYXEnthusiast
5 - Atom
‎08-30-2021
06:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am attempting to return a portion of one text column that contains the entire value of another text column. Please see the attached file for more detail. Not entirely sure why I'm unable to get the contains function to work.
Labels:
- Labels:
- Expression
- Fuzzy Match
- Regex
- Workflow
1 REPLY 1
Jotigautam
10 - Fireball
‎08-30-2021
10:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This can be achieved in much easier way by using find and replace tool.
If you want to use contains function then first you need to join both tables using Append fields and then apply formula
(IF Contains([Account - 2013], [Account - 2014]) THEN [Account - 2014]
elseif IsNull([Account - 2013]) then Null()
ELSE 'New' ENDIF).
However find and and replace is much easier way. Attaching workflow for find and replace method.
