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 

[Bhuvan]

@Aruna Nadagoun1 

Follow this during transform target field,

https://www.servicenow.com/community/developer-forum/robust-transform-get-and-apply-sysid-of-inserte...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Aruna Nadagoun1]

Hey @Bhuvan   Thanks for replying . I tried the same way mentioned No records are even getting created in Table B (subscription Details in my case) .

[Bhuvan]

@Aruna Nadagoun1 

Please check your ETL Entities and RTL Entity mappings.

You need to define the reference field mapping in RTE Entity Mapping when you copy data from Staging to Target table. I believe you are doing it in ETL entity which is why it is not working.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Aruna Nadagoun1]

We don't have option to dot walk in RTL Entity Mapping I did select Reference Entity