|
Rank: Newbie
Joined: 7/27/2016 Posts: 6 Location: Aurora, CO
|
I have a DB of records that will get mapped to an XML file. After every row in SQL is added to XML I want to add a line of data to the XML. I am querying the DB with an order number that will have multiple rows being pulled but I need to interrupt with an extra line of data. Having trouble figuring it out in Mapforce. - Jesse
|
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 558
|
What do you mean by, a "line of data"? Is it just more XML? Is it in the schema or DTD? You need to attach some samples.
|
|
Rank: Newbie
Joined: 7/27/2016 Posts: 6 Location: Aurora, CO
|
I am attaching an image of what I have built so far. I am querying a DB based on an order number then bringing over some data for each row that is queried. For each row that is brought over to XML for the tag DocFile, I need to insert another DocFile tag that will contain some static data. captcolbyjack attached the following image(s):
|
|
Rank: Advanced Member
Joined: 6/16/2006 Posts: 486 Location: AT
|
captcolbyjack wrote:I am attaching an image of what I have built so far. I am querying a DB based on an order number then bringing over some data for each row that is queried. For each row that is brought over to XML for the tag DocFile, I need to insert another DocFile tag that will contain some static data.
Connect the dbo.Orders filter to Documents in addition to the existing DocFile, do "Duplicate Input" on DocFile, connect your static data to the second DocFile.
|
|
guest |