I am using Fuzzy Database Lookup in Xtrata Pro Validation. When performing a search; no results are being returned; even though the record exists in the database. How can I resolve this issue?

Question / Problem:

I am using Fuzzy Database Lookup in Xtrata Pro Validation. When performing a search, no results are being returned, even though the record exists in the database.

How can I resolve this issue?

Answer / Solution:

This issue has been seen when the database structure has changed from the originally configured settings.

To resolve the issue, the Database structure needs to be reverted back to the original structure, or the database needs to be reconfigured in Project Builder.

For example, if the original database configuration has five columns and you insert a new row that has only four columns, then this is an unstructured row. The row with only four columns will not be used when the Fuzzy Database Lookup is executed.

Example:

...
VendorID;FirstName;LastName;Company;City
12222;Daniel;Garica;Kofax;Irvine
12223;Steve;Tanorie;Kofax;San Diego
12224;Sorin;Cojakarro;Kofax -unstructured row, only 4 columns.

Applies To: