how to set reference to another entity in a Robust Transformer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2022 04:12 AM
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 ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2022 04:16 AM
Hi, TableB value when you are going to set TableA reference field. If you explain clearly, i will try to help you.
Regards,
Suresh.
Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2022 04:24 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-02-2022 02:19 AM
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.
Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-02-2022 01:56 AM
If you can share update set with working example, I would be grateful.
Regards,
Piotr