Tuesday, 23 July 2019

SOACS - Convert delimited string to an array of XML elements.

Use following XPATH function to convert/map a delimited string to an unbounded xml element.

Use CopyList rule in assign activity to map the value.

From Value: 

oraext:create-nodeset-from-delimited-string('{http://www.TargetElementNamespace.org}$TargetElement',$InputDelimitedString,'$DelimeterValue')


To Value : 
$Unbounded Target Element Name


$TargetElement  - Unbounded Target Element
$DelimeterValue may be "," or "|" 

No comments:

Post a Comment

ERP - GL - Chart Of Accounts

Segments in General Ledger   Segments  are dimensions used to represent an account in a financial system. A company can have anywhere from...