Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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?
Ok , you have to use group instead of aggregate and all in one to true, it will
combine the output for the states.
HI, have you well set aggregate and loop element in the xmlMap ?
Send me Love and Kudos
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.
See image
Ok , you have to use group instead of aggregate and all in one to true, it will
combine the output for the states.
I see the mistake i made i read 2 guide sections as one!