I need to perform Fuzzy Search on bulk list of transactions data. Previously used Ms Excel Fuzzy search, is good but is not good for bulk data etc. 300,000+ transactions.
A bit about data, its a SAP generated file, in bulk quantity (min 300k to 1mln transactions) with 29+ columns and in a table form.
i have to perform the Fuzzy search on a unique custom made field for ex: "Vendor No + Invoice Number".
Since excel cannot handle this volume, wondering if i can get the same through Access or any other tool which i can use to perform the fuzzy search at this scale of transactions.
Please ensure that Fuzzy Search includes following criteria:
Number of matches: 3 (or we can +/- on the basis of our need.
Similarity threshold: % (ideally +85% or between 90% - 99%)
Buzz me if you can perform this task of fuzzy search or any other good alternative to achieve the task. I am happy to discuss further.
Hello Have you considered web application in which one side you upload the data and on the other side you perform the fuzzy search, we can build such a system for you which you can use on an ongoing basis. we can set it up on your domain and server if on our server as you prefer.
Let me know you interest.
Regards,
Puneet
Hi All,
Hope you are doing good.
I am too exited for this kind of excel work. I have experienced in Excel , Advanced excel, Automation Models on excel and on Google Spreadsheet. Also i have good skilled in SQL.
So i have guarantee that after completion of this project its a error free and good project.
I am always available for any kind of calculation project on excel and advanced excel.
Waiting for the further discussion for this proposal so we can close this ASAP.
Thanks & Regards
SHUBHAM