Parent and Child Transform Map

[Evren Yamin]

Hello,

Is there a way to create parent record and child record using one transform map?

Or do I need to create a business rule that will update the parent field of the record after transform?

What's the best way to do this? I tried using a field map script but it's not working.

Appreciate all the help.

[Community Alums]

Hi @Evren Yamin ,

You need to use Conditional coalesce using dot-walking where you can dot talk parent table fields from child table. 

Take a look into below:

https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/import-sets/concept/c_ImportSetCoalesce.html

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[scsn]

Hi Sandeep

The link https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/import-sets/concept/...

is not opening.

[Tony Chatfield1]

Hi, a field map script may be possible if the record you are trying to relate already exists and your source data allows a lookup match via some coalesce values, but without details of your script or data there is no way to identify your issue.

It is also possible to use an afterTransform script to create or associate records but the best solution will depend on your data and import process.

Perhaps you could provide clearer details and some example data.