Matching Values in a list

Hi Folks,

I have a list of values, about 25, that I want to match against a field in my master data set. I'm creating a indicator field with a value (Y) that indicates a match. I cannot find a function that allows me to add all the match values. In other software packages it would be called, INLIST or MATCH....does Alteryx have such a tool?

Thanks,

George

Example: MATCH([match_field], value1, value2, value3.......etc)

Datasets

Data Investigation

Accepted answers

jrlindem

I think you can just use the Find Replace tool. Since you don't care which value it matches on (I assume) but only IF it matches... Then you can allow it to seek any first value (like an excel vlookup):

I've also attached the workflow example. Hope this helps, -Jay

jrlindem_example.yxmd

All comments

jrlindem

Are these going to be exact matches?

I would put your 25 values in it's own Text Input tool and then use Join Tool against the field you're looking to match up with. The output can be flagged and then filtered....

But otherwise, can you attach starting (fake) data and expected outcome so we can attempt to build an illustration? -Jay

gfisch13

Thanks @jrlindem - should have done that from the beginning.....see attached. My list will be much larger than the one I provided and as you will see I will be trying to match on partial words so the Contains function comes to mind, I just don't know how to do this within a list.

AlteryxMatchingDummyData.xlsx

jrlindem

I've also attached the workflow example. Hope this helps, -Jay

jrlindem_example.yxmd

gfisch13

Thanks Jay, didn't even consider this as an option! Appreciate the guidance.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703