Transform map, skip record rather than ignore

[sndev1099]

Hi, 

I need my transform map to skip records rather than ignore them if the user ID doesn't exist in the system. 

[sndev1099]

Hi Slava,

I have tried using it that way but it still inserts a new record into the sys_user table which I don't want to happen if the ID doesn't exist in the system.

Import set:

[Ankur Bawiskar]

Hi,

you already have field map then don't use transform script

1) you have choice action as reject so if value not found then it would reject the row

2) did you set the reference value field name as user_name as incoming value is user's user id

set Referenced value field name as user_name

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Regards
Ankur

[sndev1099]

Hi Ankur, 

Yes, please see below. Just tried with an ID that doesn't exist and it still inserts it

[Chander Bhusha1]

Hi bracken91,

Can you please make sure that create new record on emptry colasce field on the transform map is unchecked as shown below 

The create new record on emptry colasce field will appear in the transform map level.

Uncheck the create new record on empty colasce fied as shown above.

Please mark helpful and correct.

Thanks,

CB

[sndev1099]

Hi CB, 

This is already unchecked