Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Output XML with Multiple loops

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. 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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