Data in target file is not updating - new record created when it shouldn't
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 crea...