CONTAINS from a List
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
Just trying to find out if there's a way to use CONTAINS with a list. I understand that the Find Replace Tool does offer something similar, but it does not really fulfill my need.
I have a list of items that I will need to update from time to time, and the list may grow longer or shorter depending on need. Now, the raw data that I am working with is user-input generated, meaning that I will have to get the keywords out from it.
What would be a good way to do it?
P.S: I've looked at this thread: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Using-IN-within-a-Contains-fun... and tried MarqueeCrew's method + macro. I'm hoping that someone would have some different ideas for me to try.
Thanks all!
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Labels:
- Expression
- Macros
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @caltang, are you able to share an example of data and expected outcome? From what you've described I'm not getting how a Find Replace tool wouldn't do the job here so probably need more context. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DataNath,
Thanks for helping out. I've attached the dataset.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@caltang so the issue you're having is that you're not getting a match for things like 'Reimburse expense' to 'Reimbursement'?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes! Lots more as well. I would say by any given method I've applied so far, I can only capture 40--50% of the dataset.
The alternative would be to do the rest manually and input it as a unified dataset for a final summary table etc.
But I'm trying to see how I can cover more % or 100% if possible.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hmm, I think if there's room for variation then that's when you may start getting into the need for things like Fuzzy Matching. I've never really used the tool/process myself so can't offer too much advice there. Failing that, you may just need to make your lookup table a lot more extensive.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries, I'm stuck with Fuzzy Matching too. It's an art afterall.. not a science. So it'll be a bit tough to crack at the moment. Maybe others would have solutions too.
Thanks @DataNath ! Appreciate it.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
