Robust Transform Processing Issues

[DylanBlumenberg]

Hi everyone, 

I'm attempting to use Robust Transform to process an Excel file and do the following in this order:

• Using a contract number on the Excel file, create a contract on ast_contract if one does not exist.
• Using the computer serial number on the Excel file, find an asset record.
  • If it finds a record, add the contract number to the Lease Contract field.
  • If it doesn't find a record, don't create an asset. 
• Create a record on the Assets Covered table linking the asset record to the contract record. 

I've been reviewing this document, but I think I'm misunderstanding it, specifically target field/path. Extract Transform Load (ETL) definition overview

I've created the ETL Definition, ETL Entities for the Import Set, Computer, Contract, and Assets Covered tables, created Entity Fields for each of those, and created RTE Entity Mappings to move data from the Import Set to each of the three tables. 

The areas that I'm having issues are:

1. The coalesce is not updating existing asset records with the contract number.
2. Records are being created on the Assets Covered table, but they don't contain an asset or contract, despite source and target fields being mapped to the RTE Entity.

I've attached some screenshots but I'm not sure what's helpful to see. Does anyone know where I might be going wrong?