Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to process some fields in Input XML and write the same XML back with updated Values.
so Job Design is tFileInputXML --> tMAP (Want to update the values of 2 fields) --> tFileOutputXML
I created MetaData for Input and OutputXML.
Here is example of Input XML -
<?xml version="1.0" encoding="UTF-8"?>
<EnrollmentDetail>
<ChangeType>F</ChangeType>
<NewControlAccount>
<Product>Product</Product>
<ControlAccountNumber>ControlAccountNumber</ControlAccountNumber>
</NewControlAccount>
<OldControlAccount>
<Product>Test Product</Product>
<ControlAccountNumber>ControlAccountNumber</ControlAccountNumber>
</OldControlAccount>
<OldFinancialInfo>
<FIRteTrnstNbr/><FIAcctNbr/><FIName/><FinancialInStumentType/><AliasName/>
</OldFinancialInfo>
<NewFinancialInfo>
<FIRteTrnstNbr>000100109</FIRteTrnstNbr>
<FIAcctNbr>111111</FIAcctNbr>
<FIName>BANK OF MONTREAL</FIName>
<FinancialInStumentType>Checking</FinancialInStumentType>
<AliasName>aaa</AliasName>
</NewFinancialInfo>
</EnrollmentDetail>
Now as in this XML there are multiple loop elements so output is not same as of Input, could you please help.
Here is Current Output with one element set as loop element -
<?xml version="1.0" encoding="ISO-8859-15"?>
<root>
<row>
<ChangeType>F</ChangeType>
<Product>Product</Product>
<ControlAccountNumber>ControlAccountNumber</ControlAccountNumber>
<Product1>Test Product</Product1>
<ControlAccountNumber1>ControlAccountNumber</ControlAccountNumber1>
<FirstName>jghjgjgh</FirstName>
<MiddleName>null</MiddleName>
<LastName>jghjgjgh</LastName>
<EmailAddress>jghjgj@aexp.com</EmailAddress>
<FIRteTrnstNbr></FIRteTrnstNbr>
<FIAcctNbr></FIAcctNbr>
<FIName></FIName>
<FinancialInStumentType></FinancialInStumentType>
<AliasName></AliasName>
<FIRteTrnstNbr1>000100109</FIRteTrnstNbr1>
<FIAcctNbr1>654565</FIAcctNbr1>
<FIName1>BANK OF MONTREAL</FIName1>
<FinancialInStumentType1>Checking</FinancialInStumentType1>
<AliasName1>aaa</AliasName1>
</row>
</root>
My requirement is to get the same output as of Input with updated value of those two fields.