Alteryx Designer Desktop Discussions

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

Fuzzy Match - Merge Mode - 3 Data Sources

MKlotz
6 - Meteoroid

I am working with three different data sources and want to see where all three data sources are with 80% of each other. Is there an efficient way to merge fuzzy match to accomplish this? 

1 REPLY 1
Prometheus
12 - Quasar

@MKlotz Start with your Input Data configuration. Make sure "Output File Name as Field" is set to "File Name Only." Union your files so you have one column to fuzzy match on and one column with the file name. Drop a RecordID tool into each stream and make sure they don't overlap with each other so when you join the output of the Fuzzy Match tool back to your original data, you don't end up with multiple values identified by the same RecordID. Configure your Fuzzy Match tool with the FileName as your Source ID Field and RecordID as your Record ID Field.

Labels