RobustTransformMap -string field mapped from temp to target table, Map this as Reference to 2nd Targ

[Aruna Nadagoun1]

I need to map the data into 4 Tables (subandBILLs, SubscriptionDetails, Consumer and Contact)

The data comes into (u_import_data_migration) Entity . I also set up temp Entity . You can clearly see from the below images I have set  up ETL Entities and Entity Mappings from import to temp , temp to 4 target Tables.

So Now My question is :

      I have field snumber  string I can map this as below :

1. u_import_data_migration to temp (u_snumber - u_snumber) ( string)
2. temp to subandBILLS Table ( u_snumber - u_snumber ) (string )
3. The above snumber field I need to Map to subDetails Table ( Reference)

So while running the transform how can I fetch the record of one target Table and use its sysid to map to reference field of another Target table ?

@Ankur Bawiskar  

Please let me know if you need any details.

Edit : I also used Glide lookup Operation The Result is this 

[Aruna Nadagoun1 · Accepted solution]

I raised a ServiceNow case for the same below is the response :

The current implementation you are aiming for is not possible with the available out-of-box (OOB) features in ServiceNow. Specifically, during the transformation process, it is not feasible to use a record created from one mapping directly in another mapping. Each relationship needs to remain independent during transformation.

[Bhuvan]

@Aruna Nadagoun1 

Thanks for the update and sharing the information from support case.

Thanks,

Bhuvan