I have a DB Import task that uses a Target Lookup field to find an ID based on a SKU field for a product.
Our SKU's are constructed in parts and may build on each other for various components:
- AAA-BBB
- AAA-BBB-CCC
- AAA-BBB-CCC-1
Each of the above is a single product and I need to update only the exact SKU.
The import is failing as the lookup for the first example above is finding all 3 records and the lookup must only return a single record.
How can I force an Exact Match lookup?