|
|
Rank: Newbie
Joined: 6/3/2014
Posts: 3
Location: Poland
|
I have a problem with my mapping:
In XML file i have structure with multiple rows containing different VAT percent.
For every node there is a value of net price.
In Output file i need to recieve:
distinct percent values
sum of net price.
So for a combination of data:
1200, 7
1500, 23
120, 8
158, 7
177, 23
i need to retrieve:
1358 , 7
120, 8
1677,23
Anz ideas how to do it_
I tried group adjacent, mixed with sum functions but for me it seems to not work.
Anyone can help?
|
|
Rank: Advanced Member
Joined: 6/16/2006
Posts: 486
Location: AT
|
You need group-by and sum functions and these connections:
Source product -> group-by nodes/rows -> target product
Source VAT -> group-by key
Source price -> sum values -> target sum of price
Source VAT -> target VAT
|
|
Rank: Member
Joined: 10/2/2014
Posts: 22
|
Hi there,
I am struggling with the same kind of issue, and I can't seem to resolve this.
When I create an output text file and a group by, I have my group by function working as it should, so it seems.
Input file is an Order XML with Stock keeping units.
There are Stock keeping Units with two orders on it, so you get two rows.
What I did is this:
Input Rows --> Group-by nodes/row --> output Rows
Stock keeping Unit --> Group-by key --> Output Unit
My output file gives me one row per Unit.
For a few units I get, for example, two orders and I want to add the amounts of both rows together and get a total in my output.
I have no clue where to build the Sum. I have tried searching online, tutorials and help files but I can't seem to find a detailed description of how to do this...
Any help is appreciated..
Thank you
|
|
|
guest |
