topic Aggregation and multiple loops in tHMap in Talend Studio

Aggregation and multiple loops in tHMap

monseesa — Thu, 28 Aug 2014 11:37:02 GMT

With tHMap I want to map an incoming xml file to a flat structure of data integration columns. The mapping can be viewed in the attached screenshots. As you can see, there a multiple 1:n structures in the xml. I need to loop over one of them (measurementValue->value) an I want to aggregate another one (householdServingSize->Description->text). Both of these elements have the mutual parent foodAndBeverageNutrientInformation. What I want to achieve is, that for each measurementValue under the foodAndBeverageNutrientInformation node an aggreated concatenation of the householdServingSize->Description->text is done.
But when I define the aggregation like in the screenshot, not only the text-elements under the foodAndBeverageNutrientInformation-node are concatenate. The aggregation concatenates all text-elements in the whole document.
How can it be done that only the text-elements under the same foodAndBeverageNutrientInformation-node as the measerumentValue-node are aggregated?

loop-test.… .txt

Re: Aggregation and multiple loops in tHMap

monseesa — Thu, 28 Aug 2014 11:38:06 GMT

loop-test.xml.txt_20140828-1237.txt

Re: Aggregation and multiple loops in tHMap

monseesa — Thu, 28 Aug 2014 11:39:58 GMT

My attached screenshots seem to be missing and my attached xml-file cannot be viewed. What am i doing wrong?

Re: Aggregation and multiple loops in tHMap

Anonymous — Fri, 29 Aug 2014 08:16:01 GMT

Hi monseesa,
Are you able to upload your image by chicking "Upload" button or dropping your file into "Drop files here to attache them" field?
What's the browser are you using? Could you please paste your loop-test.xml.txt_20140828-1237.txt file intpo forum directly?
Best regards
Sabrina

Re: Aggregation and multiple loops in tHMap

monseesa — Fri, 29 Aug 2014 08:25:16 GMT

Hi xdshi,
I'm using Firefox 30.0, and I tried both - the upload button and the "Drop Files"-Field. When I click on upload, I can see that I have already 12 pages under "My Uploads", but they are not shown in my post.
Here's the XML:
<?xml version="1.0" encoding="UTF-8"?>
<catalogueItem>
<tradeItem> <tradeItemIdentification> <gti

To see the whole post, download it here
OriginalPost.pdf

Re: Aggregation and multiple loops in tHMap

Anonymous — Fri, 29 Aug 2014 08:37:37 GMT

Hi,

I'm using Firefox 30.0, and I tried both - the upload button and the "Drop Files"-Field. When I click on upload, I can see that I have already 12 pages under "My Uploads", but they are not shown in my post.

When you click "upload" button and upload files, make sure the uploaded screenshots is loaded in your current post.
See my screenshots.
Let me know if it is OK with you.

Best regards
Sabrina

Re: Aggregation and multiple loops in tHMap

monseesa — Fri, 29 Aug 2014 08:40:03 GMT

Re: Aggregation and multiple loops in tHMap

monseesa — Fri, 29 Aug 2014 08:41:44 GMT

I tried as you said. I saw the screenshots in the reply formular. Then I clicked Preview and saw the screenshots, too. Then I clicked submit, and they are gone.
Edit: Strange - when I created my post, the uploaded files vanished. But when I edit the post and then attach files, it works.
Thank you!

Re: Aggregation and multiple loops in tHMap

monseesa — Mon, 01 Sep 2014 14:55:10 GMT

Doesn't anyone have an idea how this can be done with the new mapping component? Is it not possible with Talend?