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

[nathaliafh]

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!

[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 · Accepted solution]

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.