Need help on tranform map

[William08]

Hi all,

I have created a transform map and i have set coalesce field as true for RITM number, assigned to and configuration item field.
During first transform if the configuration item is empty it is creating a record which is working as expected but on the 2nd transform if loading record matches with existing record then also it is creating a record because the configuration item is empty how to aovid these? and also some of the records are updating instead of ignoring, even though loading record is matching with existing record why is this happening?

Thanks in advance

[Ramz]

Hi @William08 ,

To avoid new records from getting created when the target table does not contain the value set Choice action of the field to 'ignore'

Please mark my answer correct/helpful if it resolved your query.Thanks

[William08]

Hi @Ramz,

Thank you it helped me also one more question can i set coalesce to true for assigned to in field map and also use on before script to ignore the insertion of row if assigned to user is inactive?

[Ramz · Accepted solution]

Hi @William08 ,

Yes you can do that .Test in sub-prod if there are any conflicts

Please mark my answer correct/helpful if it resolved your query.Thanks

[William08]

Thank you @Ramz