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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

nested loops TXMLMap How to extract these values ?

Hello Community,

 

I have a problem when I'm trying to read XML from tRestclient > tXMLMap

 

0683p000009LwSA.png

 

tRestclient GET message :

 

<content type="application/xml">
<m0683p000009MAB6.pngroperties>
<d:FileSystemObjectType >0</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>health</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>198</d:element>
<d:element>101</d:element>
</d:c3vxId>

</m0683p000009MAB6.pngroperties>

<m0683p000009MAB6.pngroperties>
<d:FileSystemObjectType >1</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>human</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>200</d:element>
<d:element>101</d:element>
</d:c3vxId>
</m0683p000009MAB6.pngroperties>

<m0683p000009MAB6.pngroperties>
<d:FileSystemObjectType >2</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>technology</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>108</d:element>
<d:element>101</d:element>
</d:c3vxId>

</m0683p000009MAB6.pngroperties>
</content 

0683p000009LwwX.png

 

the problem is that I can't loop on </d:c3vxId>  because it's a child node.

0683p000009Lwsw.png

Do you have any solutions for this please ? 

thank's

 

Labels (4)
2 Replies
manodwhb
Champion II
Champion II

Anonymous
Not applicable
Author

Yes,  when I use the loop on the child node (d:element) it doesn't loop on the higher level (m0683p000009MAB6.pngroperties)

finally I used tExtractXMLField.