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

I want to get Txmlmap output in single document instead of 2 seperate documents

I made the option of txmlmap all in one true, but I still get 2 different  documents, any solution please;

out put:

<?xml version="1.0" encoding="UTF-8"?>
<geocodereponse><result><geometry><location><lat>45.49133</lat><long>-72.312679</long></location></geometry></result></geocodereponse>
<?xml version="1.0" encoding="UTF-8"?>
<geocodereponse><result><geometry><location><lat>45.373436</lat><long>-71.9029483</long></location></geometry></result></geocodereponse>

 

what i need:

<?xml version="1.0" encoding="UTF-8"?>
<geocodereponse>
<result>
<geometry>
<location>
<lat>45.49133</lat>
<long>-72.312679</long>
</location>
</geometry>
</result>
<result>
<geometry>
<location>
<lat>45.373436</lat>
<long>-71.9029483</long>
</location></geometry>
</result>
</geocodereponse>

 

0683p000009M2ON.png

 

0683p000009M1S6.png

 

Labels (3)
3 Replies
vapukov
Master II
Master II

Hi,

 

as you can see from your screenshot (it better than the previous one describe the problem) - you have 2 rows after tRESTClient

 

it means, you receive not a single XML Document with Loop by location, but 2 independent XML documents, and in this case tXMLMap work as expected

 

 

 

 

as variant of solution - store data to hash (more than one if need) and prepare output XML after receive all

 

Anonymous
Not applicable
Author

I am new developer in talend, can you please advise me how to proceed
vapukov
Master II
Master II

just split job into 2 subjob

 

  1. First as is, but store extracted values to - csv, database of tHashOutput (all in append mode)
  2. Second - prepare final XML from stored data - Input component -> tXMLMap -> Output component