GD, Forum Users I got the following problem; hopefully as you’re the forum-analytic gods you will be merciful with this poor guy’s problem. I got a big big list of string inputs (1000k+). These inputs should have been standarized and only should have been input only when chosen from a 1k options list but things did not go as planned and data is now a mess; writing each input with different characters, random digits, missing letters, words in different order, etc… I need to narrow down the original 1k option list. At first, thought fuzzy match would be my solution but i need the “dictionary”, or the 1k list so it can match the different inputs. Now i think i need to string manipulate and get the 1k option list manually, checking the inputs 1 by 1. So far i’ve tried string manipulation to remove digits and specific words, groupby node but still, my selection is way too big to do it manually. screenshot [ej] COULD YOU PLEASE HELP ME!?!? How would you approach this problem? Many thanks in advance, guys!

FUZZY MATCH ALTERNATIVES

izaychik63 January 18, 2023, 7:22pm 4

@jmanuelml21 , look at this trail:

The approach somewhat simpler. If you prefer different metrics just connect String Distance to Similarity Search node.

You can connect WF from the trail above.
The idea to compare same lists.

1 Like