Hi Everyone I have a condition where I want to match result if data in source A contains data from source B Sample as follow Data AData BResultABCDABMatch and put out resultAB BCAB BMatch and put out resultABCDFABCDFGHNot matchADH JKLJKLMatch and put out result I have tried to use fuzzy match to solve this issue, however it seems that I need to lower the threshold drastically. As such, some solution that can provide result/do filtering using contain if would be great Thank you in advance!

Perform partial lookup/get contain if result based on another data set

Hi Everyone

I have a condition where I want to match result if data in source A contains data from source B

Sample as follow

Data A	Data B	Result
ABCD	AB	Match and put out result
AB BC	AB B	Match and put out result
ABCDF	ABCDFGH	Not match
ADH JKL	JKL	Match and put out result

I have tried to use fuzzy match to solve this issue, however it seems that I need to lower the threshold drastically. As such, some solution that can provide result/do filtering using contain if would be great

Thank you in advance!

Workflow

Tips and Tricks

Join

Accepted answers

jdminton

I'm not sure if this will work in your situation, but if the data is not too large, you can use this join to perform what you are asking. It creates a cartesian join though so the number of records will be multiplied between the two tables (i.e. 1000 records in table A and 1000 records in table B will generate 1,000,000 rows). If you have a large data set, you might need to create an iterative macro to test each record one at a time. Let me know if this is what you're looking for.

Partial Lookup.yxmd

All comments

kamal03

Hi @nathaliafh

The provided information suggests using the Contains function within the Formula tool in Alteryx to achieve an outcome.

If you could provide more context about your specific task, I can offer a more tailored solution using the Contains function or suggest alternative approaches.

if Contains([Data A],[Data B])
then
'Match'
else
'Not match'
endif

nathaliafh

Hi Kamal,

Thanks for the reply! Currently it's coming from 2 different input data sources. I am not sure if formula will work directly in this case?

philipmannering

You would need to join your data. Or are you checking every record from Data A against every record from Data B?

nathaliafh

Hi Philip,

Essentially yes. I would like to check for potential match on each record from Data A with Data B

jdminton

Partial Lookup.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703