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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tXMLMap loop through root and child nodes.

Hello,
I have a problem regarding loops in tXMLMap. Since TXmlMap doesnt allow to have a loop on both root and child elements, I cant seem to figure out the way to complete my task. I need to send payload to tESBProviderResponse with same schema as a response from a web service. I marked the elements that should be looped through in the image, and also provided with a way my response should look like.
LINK TO THE IMAGE: http://postimg.org/image/g7hjsv7gf/full/
Can anyone link me to a tutorial on that would solve this problem, or supply me with a solution?
Thank you in advance,
Algimantas
Labels (3)
10 Replies
Anonymous
Not applicable
Author

Rhall,
I am struck here again.
In tExtractyXMLfiled We can iterate through loops.
But after that I need to filter only those Whose parent's parameters are validated against certain expectations.
I want to get the country where the address type = Physical and valid = yes .
Am using tXMLMap, I have put the Loop at address level and then Filtering the items in expression builder where address type = Physical.But I don't know how to check " valid = yes "
Example:
<Locations>
<location valid="yes">
<contact>
<address>
<type>LL</type>
<country>ES</country>
</address>
<address>
<type>Physical</type>
<country>IT</country>
</address>
</contact>
</location>
<location  valid="no">
<contact>
<address>
<type>LL</type>
<country>GB</country>
</address>
<address>
<type>Physical</type>
<country>MI</country>
</address>
</contact>
</location>
</Locations>