I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem
Fuzzy search sorts the data, so perform a selection with it'll select all the data. If you want to do it with, as an alternative, joker char *, you can:
Create a variable
Create an input box, set the variable
Ask your user to enter value, separated by comma
Create a action button, with action "Select values matchin search string"
Use an expression like this: =$(=chr(39))$(=Replace('(*$(vFuzzyNameSearch)*)',',','*|*'))$(=chr(39))
