Transform map script variables error = true and ignore = true, are not working as expected

[Priyanka Pawar1]

Hello All,

Recently I am working on a script part where I am making email as my coalesce filed, and trying to insert and update data in to the sys_user field.

somehow my error = true is not working in my email script,  when email is empty I am ignoring the records. but I am falling to do so it is picking up the data and updating the rendam records, which dont have the email address.:-

Email script:-

please find below my code for email script:-

when my this email script did not worked, I wrote it in to before script, it did worked, but once the error is set, all the other transaction of import sets are setting to pending.

so I went for ignore = true in on before script

here as well now data is not anymore updating any remdom record, but creating the records with empty email address, with only company and domain name:-

On Before script:-

Import set logs where my second code did ignore the records:-

But still The users got created with empty column only with 2 or 3 fields, which is company and domain

Kindly help me understand what i am doing wrong over here

Regards,

Priyanka Pawar

[Allen Andreas]

Hello,

If you're using a before Transform Map script that could evaluate to ignore = true and "it's not working", then you need to do 2 things:

1. Double-check that the source field name is correct and is actually empty...please use log entries to help you troubleshoot.
2. Please ensure there is not another transform map running after this first one is ignored.

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

[Priyanka Pawar1]

Hello Allen,

Yes I am using a before transform map, and it is ignoring the such records, but somehow exact same records, which has been ignored, email was empty. and no there is no other transform map is running at that time.

on the import set table for such records the target record is empty, state is ignored, but when i match the empty records which has been created in sys_user table is exact same which has been ignored due to empty email

Regards,

Priyanka Pawar

[Allen Andreas]

Hi,

Yes, I can see what you're showing in your screenshots, but what I'm saying is that transform maps don't work like that.

If the before transform map script is setup properly, if you ignore = true in it...it will stop processing and not insert or do anything else to those records.

It WILL...however...still run any "after" transform scripts. So if you've been testing around, doing things, etc. then please check for any after scripts and disable them/delete them.

Otherwise, the transform map script process would work properly.

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

[Allen Andreas]

Hi Priyanka,

Thanks for marking my above reply as Helpful.

If it also ends up guiding you Correctly, please also mark as Correct.

Thanks and take care! 🙂