Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
JeroenL
Contributor III
Contributor III

Following Talend guide and i get different output then what the guide shows

Hello,

I have been following the guide on this link https://help.talend.com/r/oF8xI4O2NvHPfUit2M6rZQ/h50EwFaWYvVKEeVaIuXncA

I'm using Talend open studio 7.3.x

According to the guide it should combine the output for the states like;

0695b00000F7vNaAAJ.png

But the output i'm getting is;

<?xml version="1.0" encoding="UTF-8"?>

<customers>

 <customer>

   <LabelState>Connecticut</LabelState>

   <Name>

     <id>1</id>

     <CustomerName>Griffith Paving and Sealcoatin</CustomerName>

   </Name>

 </customer>

</customers>

<?xml version="1.0" encoding="UTF-8"?>

<customers>

 <customer>

   <LabelState>Ohio</LabelState>

   <Name>

     <id>2</id>

     <CustomerName>Bill's Dive Shop</CustomerName>

   </Name>

 </customer>

</customers>

<?xml version="1.0" encoding="UTF-8"?>

<customers>

 <customer>

   <LabelState>Connecticut</LabelState>

   <Name>

     <id>3</id>

     <CustomerName>Glenn Oaks Office Supplies</CustomerName>

   </Name>

 </customer>

</customers>

<?xml version="1.0" encoding="UTF-8"?>

<customers>

 <customer>

   <LabelState>Ohio</LabelState>

   <Name>

     <id>4</id>

     <CustomerName>DBN Bank</CustomerName>

   </Name>

 </customer>

</customers>

I have the exact same settings as in that guide, can someone pls confirm this guide or the program ain't functioning as stated?

Labels (2)
1 Solution

Accepted Solutions
gjeremy1617088143

Ok , you have to use group instead of aggregate and all in one to true, it will

combine the output for the states.

View solution in original post

5 Replies
gjeremy1617088143

HI, have you well set aggregate and loop element in the xmlMap ?

Send me Love and Kudos

JeroenL
Contributor III
Contributor III
Author

yes, the jobs before that job in the guide work as intended.

adding the aggregate option to that value or removing it gives both the same results.

JeroenL
Contributor III
Contributor III
Author

 

See image0695b00000F7wA3AAJ.png

gjeremy1617088143

Ok , you have to use group instead of aggregate and all in one to true, it will

combine the output for the states.

JeroenL
Contributor III
Contributor III
Author

I see the mistake i made i read 2 guide sections as one!