Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
monseesa
Contributor

Aggregation and multiple loops in tHMap

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?
0683p000009MEpE.jpg
0683p000009MEol.jpg
0683p000009MEpJ.jpg
loop-test.… .txt
Labels (3)
8 Replies
monseesa
Contributor
Author

loop-test.xml.txt_20140828-1237.txt
monseesa
Contributor
Author

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

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
monseesa
Contributor
Author

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
Anonymous
Not applicable

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.
0683p000009MEgo.png 0683p000009MEfj.png
Best regards
Sabrina
monseesa
Contributor
Author

0683p000009MEpE.jpg
 
 
0683p000009MEol.jpg
0683p000009MEpJ.jpg
monseesa
Contributor
Author

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. 0683p000009MPcz.png
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!
monseesa
Contributor
Author

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