Since invoice capture lost support we are trying to determine how to replace it with Smart Fields.

When creating rules for a lookup table your options are very concrete.

For example I can say return vendor where street address = X or street address contains "X"

But how do I search for the best match given multiple columns which could also be fuzzy input data in the same way we do with Invoice Capture vendor lookups.

For example I am looking for the top match where Street, Zip, State, and City are as close as possible to the values from Smart Fields but they do not need to be exact. This is different than using combinations of Like or Equals on specific columns. It is a holistic reference to all columns at once to return the most likely result even if the address is slightly off or parts of the data are missing.

Manually configuring chain instructions like

Look for address = [No Results]

Look for address contains only street name [No Results]

Look for address contains only number [5 Results]

Do we have a Zip, filter by Zip [2 Results]

etc etc etc in Workflow I will create a giant plate of spaghetti