Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Search text into Large data column ( partial match)

619sandesh
6 - Meteoroid

Hi,

I need to perform name search which having 100+ record which i need to search in data set of company names.

Data set is having record  10,000+ and usually name to be search 100-1000 record to be search. How can we search by partial match.

Please help me with the workflow

 

Name to be Search

Name to be search
ABC Europe
Johnson & Control
Muthroot golden fin corp ltd

 

 

 

Data Set sample table 

Company NameCompany IDCityTAN
ABC capital LLC2145746PuneABCdd445
ABC europe ltd156454LondonABCd4565s
Apple 554887NewyorkAadjas114
Johnson and control limited6448484NewyorkBBBDD145
Reliance capital5445555MumbaiAAAD554
Muthroot golden finance corp limited8877455MumbaiASAAS55
3 REPLIES 3
binuacs
21 - Polaris

@619sandesh may be you can try the attached workflow, adjust the match score if you want in the program

image.png

619sandesh
6 - Meteoroid

Getting error as module not found

binuacs
21 - Polaris

@619sandesh i think you need to upgrade your python to latest version or another option is to try the fuzzy match tool

image.png

Labels
Top Solution Authors