
Contributor
2014-08-28
07:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
708 Views
8 Replies

Contributor
2014-08-28
07:38 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
loop-test.xml.txt_20140828-1237.txt
708 Views

Contributor
2014-08-28
07:39 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My attached screenshots seem to be missing and my attached xml-file cannot be viewed. What am i doing wrong?
708 Views

Anonymous
Not applicable
2014-08-29
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
708 Views

Contributor
2014-08-29
04:25 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
708 Views

Anonymous
Not applicable
2014-08-29
04:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
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
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
708 Views

Contributor
2014-08-29
04:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
708 Views

Contributor
2014-08-29
04:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
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!
708 Views

Contributor
2014-09-01
10:55 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Doesn't anyone have an idea how this can be done with the new mapping component? Is it not possible with Talend?
708 Views
