[resolved] Output XML with Multiple loops

Anonymous — Wed, 01 Feb 2017 22:05:03 GMT

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.

Re: [resolved] Output XML with Multiple loops

Anonymous — Mon, 06 Feb 2017 00:50:50 GMT

Hi,
We see that this topic has been set as resolved. Feel free to let us know if this issue still repro on your side.
Best regards
Sabrina

topic Re: [resolved] Output XML with Multiple loops in Talend Studio

[resolved] Output XML with Multiple loops

Re: [resolved] Output XML with Multiple loops