I have created 1: n link between 2 tables vehicle and warranty. vin (vehicle identification number) is the key which I have used for joining.
Vehicle Table - has auto pk in all:vehicle
Warranty Table - has auto pk in all:warranty. warranty certificate number is defined as a key in extension schema (nmx:warrranty)
In the workflow for loading data for warranty schema I am using warranty certificate number as the reconciliation key.
When particular vin is not present in vehicle table corresponding record should be rejected in warranty schema but its inserting for me.
Could anyone provide some suggestions on how to fix this issue.
Is this for Campaign Standard or Classic?
One way to do it is to exclude all "vin is empty" from being populated with an exclusion:
Classic – https://cpcontents.adobe.com/public/newlearner/newlearner_be08c5ee.html#/learningProgram/6962/overvi...
Standard – https://helpx.adobe.com/lt/campaign/standard/automating/using/exclusion.html
Sorry for the delay and please let me know if this works for you