Hi all,
I'd like to build a workflow wherein my expected output is that the names will be consolidated meaning if they are the same (not exact match, regardless of any punctuations and case insensitive) it will consolidate into a single name. Example "Ernst & Young LLP" and "Ernst and Young Australia" they are both Ernst & Young and I would like to consolidate this into a single name, "Health Assured Ltd - AU" and "Health Assured Ltd - FR" are also the same, or "AT&T - PO BOX 5017" and "AT&T - PO BOX 6463" are also the same. My data file mostly consist of a single field/column with the lists of names. I tried using fuzzy match and adjusting the threshold but the output was not the one I'd expected, it shows a 2-column with the same results and most of the names are repeated.
I attached a sample of my data file.
Thank you in advance.
