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

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