Announcing Liquid Studio 2021 v19.0.13:
- Fixed issue resyncing data sources in Data Mapper
- General Fixes
Download a Free Trial:
https://www.liquid-technologies.com/trial-download
Liquid XML is the ultimate XML Development and Data Transformation Environment including Graphical XSD Editor, JSON Schema Editor, XML Editor, JSON Editor, WSDL Editor, XML Diff tool, Web Service tools and the worlds most advanced XML Data Binding tool to generate C++, C#, Java, VB .Net and Visual Basic 6 code from your XML Schema (XSD, XDR, DTD).
Announcing Liquid Studio 2021 v19.0.13:
Download a Free Trial:
https://www.liquid-technologies.com/trial-download
Announcing Liquid Studio 2021 v19.0.12:
Download a Free Trial:
https://www.liquid-technologies.com/trial-download
Announcing Liquid Studio 2021 v19.0.11:
Download a Free Trial:
https://www.liquid-technologies.com/trial-download
We recently received a support ticket where the user wanted to generate a sample XML document for each row within an Excel spreadsheet.
This is easy to achieve using Liquid Data Mapper.
Here is our Spreadsheet data:
And here is a simple Data Mapping to create an XML document from the Excel data:
However, this will create a single XML document containing all rows from the Excel spreadsheet. In order to output multiple XML documents, i.e. one per row, we need to make a few simple changes:
When we run the updated transform, we now see three XML documents are generated 'The Graveyard Book.xml', 'The Portable Door.xml' and 'XML Schemas.xml'. Each XML document contains the Row data specific to the book.
Please see the data mapper documentation for additional information about transforming Excel to XML in Liquid Data Mapper.
Download a Free Trial of Liquid Data Mapper:
https://www.liquid-technologies.com/trial-download