In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

CONTAINS from a List

caltang
17 - Castor
17 - Castor

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!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
6 REPLIES 6
DataNath
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

Hi @DataNath,

 

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

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
DataNath
17 - Castor
17 - Castor

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

 

DataNath_0-1683636511763.png

caltang
17 - Castor
17 - Castor

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.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
DataNath
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

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.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors