Hi @arun_tirumala ,
On alm_hardware table, Create a Field called Contract and reference this field with Contract Table. Now when ever you do import, MAP this new field on with the contract data field in the data source. When you do upload, all contract records will be linked as required.
wo Options you can do (with code and without code)
1. Write a code in existing transformation MAP to make entry of Asset name (Created after import) and Contract in "clm_m2m_contract_asset" table.
| onAfter |
When: The onAfter event script is processed at the end of a row transformation, after the source row has been transformed into the target row and saved. |
2. MAP Comments field of Hardware table to have Contract data and Upload all data in Hardware table
Once all data get uploaded in Hardware table, personalize table list view and select only Asset Name and Comment. Now download all records with Asset Name and Comments (having contract information).
Again upload this data into clm_m2m_contract_asset table.
From this solution :https://www.servicenow.com/community/itsm-forum/how-do-i-connect-imported-assets-with-contracts-in-a...
