How to stop inserting the records in Target table

[Jafrin Jack]

Hi,

Using data source and Table Transform map, I am mapping the required data from import set table to Target table(user table).

Making the Employee ID(import set table) and User ID(Target table) as a Coalesce field.
Employee endate in the import set table will map to the endate field in the target ta...

So if the required ID is matched in the Target table then the data is getting Updated, but meanwhile even though there is no user ID is found in user table, the enddate is getting inserted in target table, which will not have any other user details except the userID.

How can we stop data getting inserted into target table. Do we have to implement any script in the transform map? Suggestions please

[Nikita30]

Hi Jafrin Jack,

Please create one onBefore transform map script and try to add the below code in the script

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

if (action == 'insert') {
ignore = true;
}

})(source, map, log, target);

Please mark the response as Helpful/Correct, if applicable. Thanks!