Aggregation and multiple loops in tHMap

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?loop-test.… .txt

Re: Aggregation and multiple loops in tHMap

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 regardsSabrina

--Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Aggregation and multiple loops in tHMap

Re: Aggregation and multiple loops in tHMap

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!