CONTAINS from a List

Question

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-function/td-p/109465 and tried MarqueeCrew's method + macro. I'm hoping that someone would have some different ideas for me to try.

Thanks all!

caltang · Answer

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.

DataNath · Answer

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.

caltang · Answer

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.