edited 2 weeks ago
2 weeks ago
Thank you for your reply.
To use the Lookup mapping, you need to have a column (or a set of columns) that uniquely identifies a record, other than the primary key or Lookup Column.
In order to detect which operation we need to perform (Insert or Update) we need to check if provided ID (from source) exists in the target or not. For this, we use the ID column as a Result Column. But in order to find it we need to use other columns as Keys. The Parameters section is used to specify the mapping between used Keys and source columns to detect the unique record in the target system.
The settings we provided you above work this way:
1. We execute this query: SELECT ID FROM customers WHERE Name (source)= Name (target) AND Status (source)= Status (target).
2. Then if ID exists we will go to perform Update, if ID is null - to Insert.
Please try these settings and let us know the results.