Data in target file is not updating - new record created when it shouldn't

[Kirsten2]

I have a xls file with columns and data loaded in to an import set table:

I then transform using TMap with mapped fields. Purchasing Document is a unique field so coalesce is true.

After Transform I check the ast_contract and a new record is created instead of updating the existing record. The Contract Number is the PO# and is unique in the xls and import file.  The first record is the one that was created when it should have been the second record updated. Also, the first record was created without the PO# even though it is in the import file.

What have I missed? Thank you!

[Kirsten2]

The PO# in ast_contract and the import file is string. In the excel that field is General.

[Ankur Bawiskar]

@Kirsten2 

share your field map screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.