Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

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

nathaliafh
6 - Meteoroid

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 BResult
ABCDABMatch and put out result
AB BCAB BMatch and put out result
ABCDFABCDFGHNot match
ADH 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!

5 REPLIES 5
kamal03
9 - Comet

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

 

Screenshot_3.png

nathaliafh
6 - Meteoroid

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
16 - Nebula
16 - Nebula

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

nathaliafh
6 - Meteoroid

Hi Philip,

 

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

jdminton
13 - Pulsar

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.

Snag_d479e10.png

 

Snag_d47da3e.png

Labels
Top Solution Authors