CONTAINS from a List

[caltang]

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!

[DataNath]

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!

[caltang]

Hi @DataNath,

Thanks for helping out. I've attached the dataset. 

[DataNath]

@caltang so the issue you're having is that you're not getting a match for things like 'Reimburse expense' to 'Reimbursement'?

[caltang]

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.

[DataNath]

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]

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.