how to set reference to another entity in a Robust Transformer

ashrafi
Tera Contributor

Hi All,

I am inserting the a record in two separate table using robust transform map, but facing one issue of Reference field.

eg:- Table A has a reference field which is refer to table B. I want to set the sysId of record created in table B to the reference filed of Table A.

Any suggestion will be valuable ...

9 REPLIES 9

ersureshbe
Giga Sage
Giga Sage

Hi, TableB value when you are going to set TableA reference field. If you explain clearly, i will try to help you.

Regards,

Suresh.

Regards,
Suresh.

Using robust Map I am storing the record in two table i.e  Table A and Table B.

Table A has reference field name as (Group ID), now I want to set the Sys_ID of newly created record in table B to the GroupId field of Table A via robust transform map.

Please let me know who Table A and Table B record os creating both are creating simultaneously. 

Are you using the import set table concept to create/update the record in target tables?

Regards,

Suresh.

 

 

Regards,
Suresh.

sc
Tera Contributor

@sureshloganathan I'm struggling with the same problem. Using RTE (Robust transformer) I'm creating records to two tables (cmdb_ci) and (cmn_location). The problem is with creating relations (set location field with value of newly created cmn_location). I have tried to set Referenced entity pointing to location on cmdb_mapping (location field), but still this field isn't populated. 

If you can share update set with working example, I would be grateful.

Regards,
Piotr