What's the error? I created a sample file of the same structure (sample.xml) and then created a table transform map with the following script:
(function transformRow(source, target, map, log, isUpdate) {
try {
// Extract XML from the source table fields
var headerXml = source.u_header; // Replace with the actual field name for the header XML
var controlInstancesXml = source.u_control_instances; // Replace with the actual field name for the control instances XML
// Parse the XML for <POLICY_ID> from <FILTERS>
if (headerXml) {
var headerDoc = new XMLDocument2();
headerDoc.parseXML(headerXml);
var policyIdNode = headerDoc.getNode('/HEADER/FILTERS/POLICY_ID');
if (policyIdNode) {
var policyId = policyIdNode.getTextContent();
target.u_policy_id = policyId;
} else {
// POLICY_ID node not found in HEADER XML
}
} else {
// HEADER XML is empty or missing
}
// Parse the XML for <TOTAL> from <CONTROL_INSTANCES>
if (controlInstancesXml) {
var controlDoc = new XMLDocument2();
controlDoc.parseXML(controlInstancesXml);
var totalNode = controlDoc.getNode('/CONTROL_INSTANCES/TOTAL');
if (totalNode) {
var total = totalNode.getTextContent();
target.u_policy_total = total;
} else {
// TOTAL node not found in CONTROL_INSTANCES XML
}
} else {
// CONTROL_INSTANCES XML is empty or missing
}
} catch (e) {
log.error('Error during Transform Map script execution: ' + e.message);
}
})(source, target, map, log, action === "update");
