Transform Map inserts multiple records in user table!!

[Rakhesh]

Hi Guys,

We are troubling with one issue using transform map. Briefly, We are getting the data form database view by using transform maps we are insert into user table.So we gave Coalesce to one unique field, still we are getting duplicate records in user table.

we are noticing the issue i.e., example if user has a different emails then it is inserting into user table.we have an unique email i'd and ending with our 'company name'. So we need only those records. How we can achieve this ??? 

Thanks,

Rakhesh

[rammohanraomadd]

Hi Rakhesh,

There is no empId defined anywhere in the script. I hope you need to add email in the query. Please update the same and let me know for any queries.

Also it would be helpful if you can explain your issue some example.

Regards,

Ram M 

[Rakhesh]

sorry ram, it's my bad we added 'email 'already in the query instead of 'empid' .

please find below example for reference

[rammohanraomadd]

Hi Rakhesh,

You want to ignore the record which contains the gmail and you want to insert or update the record with your company name in the email. Is that correct?

Regards,

Ram M

[Rakhesh]

yes ram exactly!!

[rammohanraomadd]

Hi Rakhesh,

Please use the below on before transform script:

var email = source.u_email;
if(email.indexOf("@service-now") == -1)//Replace service-now with your company name that is exists in the email id that you mentioned above.
ignore = true;

Regards,

Ram M