|
|
Rank: Newbie
Joined: 11/22/2019
Posts: 9
|
I try to map csv file output to nested XML.
XSD is created like this
1 or more users have netprices of 1 or more products, the products have 1 or more different quantities with their prices.
But Altova MapForce creates a XML output like this
User has product with one quantity and the price, and the same user has the same product with another quantity and the price...
I need to create output XML like this
user1 has netprices of product1 with quantity1 and price1 and product2 with quantity2 and price2 en product3 and so on
user2 has netprices of product1 with quantity1 and price1 and product2 with quantity2 and price2 and product3 and so on
user3 has netprices of product1 with quantity1 and price1 and product2 with quantity2 and price2 and product3 and so on
How to achieve this?
Please help!
|
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 564
|
It appears you me your output sample doesn't contain the same data as your input sample, but perhaps the attached example.mfd will help you understand how to use group-by. File Attachment(s):
 example.mfd (5kb) downloaded 145 time(s).
|
|
Rank: Newbie
Joined: 11/22/2019
Posts: 9
|
K101 wrote:It appears you me your output sample doesn't contain the same data as your input sample, but perhaps the attached example.mfd will help you understand how to use group-by.
Thank you very much! That is what I needed. It works now!
|
|
|
guest |
