SOLVED
Search text into Large data column ( partial match)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
619sandesh
6 - Meteoroid
‎12-18-2024
10:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 Name | Company ID | City | TAN |
ABC capital LLC | 2145746 | Pune | ABCdd445 |
ABC europe ltd | 156454 | London | ABCd4565s |
Apple | 554887 | Newyork | Aadjas114 |
Johnson and control limited | 6448484 | Newyork | BBBDD145 |
Reliance capital | 5445555 | Mumbai | AAAD554 |
Muthroot golden finance corp limited | 8877455 | Mumbai | ASAAS55 |
Solved! Go to Solution.
Labels:
- Labels:
- Batch Macro
- Datasets
3 REPLIES 3
binuacs
21 - Polaris
‎12-19-2024
03:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@619sandesh may be you can try the attached workflow, adjust the match score if you want in the program
‎12-19-2024
06:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Getting error as module not found
binuacs
21 - Polaris
‎12-19-2024
08:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@619sandesh i think you need to upgrade your python to latest version or another option is to try the fuzzy match tool
