Re: "FLAT" XML to Hierarchical XML
My hope was to put in a filler value until I get real values from my DB. List first "unique" customer with an ID of 1, then also use a CustomerID in the orders part of the XML during the transformation that matches (1). For the OrderID I can use the Order_Number I am getting from my partner, and then when I send it to my DB my OrderID numbers will be used instead.
" ... I have no way of knowing if the customer already exists in my DB until I attempt to add them."
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format