IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

How to unflatten a record Options · View
Toby
Posted: Wednesday, June 21, 2017 7:08:56 AM
Rank: Newbie

Joined: 6/9/2017
Posts: 6
Let's say I have a database record with several text fields (text1 - text5) that I need to map into XML as multiple nodes of <NOTES><NOTE>text</NOTE> ... <NOTE>text</NOTE></NOTES>.

How would one go about doing something like that?
paul
Posted: Wednesday, June 21, 2017 10:46:20 AM
Rank: Advanced Member

Joined: 9/9/2005
Posts: 483
Location: AT
Hi,

It sounds like you need to duplicate the target nodes 5 - or as many - times as you require...
Toby
Posted: Wednesday, June 21, 2017 9:14:53 PM
Rank: Newbie

Joined: 6/9/2017
Posts: 6
SWEET!

That's non-obvious but perfect!

Would be nice to have an example added to the help specifically asking/answering this question, as I've seen a number of databases that have this type of scenario. Would make it easier to find.

E.g. Mulitple text/comment fields in a source record and the target has a child table of text/comment records - or VV.

Thanks!
K101
Posted: Thursday, June 22, 2017 7:09:42 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 441
For what it's worth, the documentation does describe the Duplicating Input feature, and MapForce comes installed with two example files (ContactsFromPO.mfd and TokenizeString2.mfd) which exhibit the functionality.
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.