This content has been marked as final. Show 2 replies
Please set "Treat Source Rows" as "Insert" then retry.
It should work.
Please make below changes to make sure that it records the change in the NewLookupRow:
- Make sure that the lookup ports are passed to the subsequent expression tranformation
- Enable "Insert else update" option in the Lookup Properties.
Once these changes are made the NewLookupRow should change to 2.