Split multiple comma separated keys and create individual records in Key values table via IH-ETL

[Lalitha G]

Hello,

We have created custom CMDB integration with a tool (Example: ABC Tool) and have used IH-ETL for field mapping. Now, we have a new requirement to map the tags associated with the device in source tool to the respective CI in ServiceNow CMDB.

Tags from source tool are available as comma separated values and we want to use Key Values [cmdb_key_value] table in ServiceNow for associating tags to the CI. Below is the example of how the mapping should look:

Sample Tag Value of a device 'UTS-13SH' from Source: network,ha-active,internal use

Target Mapping in ServiceNow Key Values table:

Configuration Item	Key	Value
UTS-13SH	ABC Tool	network
UTS-13SH	ABC Tool	ha-active
UTS-13SH	ABC Tool	internal use

We have used attached mapping in ETL and it is creating a record in key value table as below:

Configuration Item	Key	Value
UTS-13SH	ABC Tool	network,ha-active,internal use

Please help us with the solution to split the tags and individually associate it to the CI.

[pavani_paluri]

Hi @Lalitha G ,

You'll need to implement custom transform logic because default IH-ETL does not support multi-row expansion from a single field directly.

Go to ETL MAP, Open target table "cmdb_key_value". Add a new OnBefore or OnAfter script to loop through source values network, ha-active, internal use and attach to CI.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P