Liquid Data Mapper - Data Manipulation

The Liquid Data Mapper makes building complex data transformations quick and easy, but before you start there are a few basic concepts you need to learn.

Data Manipulation

In this this example we will show how to read data from a source file and copy it to the output target file, but we will also convert the 'Name' field values to upper case as we copy the values.

To do this we need to drag the 'Upper' component on to the canvas from the 'Component Palette' (see the View menu if it’s not visible) and connect the 'Name' field input and output nodes.

The data source will be an XML file based on the same root element as the destination:


Liquid Data Mapper - Data Manipulation

The sample shows XML data being used to create an XML document, when you run the transform you will see the resulting XML document with the 'Name' fields converted to upper case:

<!--Created by Liquid Data Mapper Libraries (www.liquid-technologies.com) -->
<Contacts>
    <ContactDetails>
        <Name>ALESHIA TOMKIEWICZ</Name>
        <PhoneNumbers>01835-703597</PhoneNumbers>
    </ContactDetails>
    <ContactDetails>
        <Name>EVAN ZIGOMALAS</Name>
        <PhoneNumbers>01937-864715 , 01714-737668</PhoneNumbers>
    </ContactDetails>
    <ContactDetails>
        <Name>FRANCE ANDRADE</Name>
        <PhoneNumbers>01347-368222</PhoneNumbers>
    </ContactDetails>
    <ContactDetails>
        <Name>ULYSSES MCWALTERS</Name>
        <PhoneNumbers>01912-771311 , 01302-601380</PhoneNumbers>
    </ContactDetails>
     ... etc ...
</Contacts>

Tip: You can execute a transform by pressing Shift-F5.

A free trial of the Liquid Data Mapper is available from:
https://www.liquid-technologies.com/trial-download