This section should demonstrate several common tasks which can be done in XiMpLe with a minimal effort.
For more information please see the user's guide which is available in the section download.

Example 1. Copy texts from a simple xml table to Excel
Example 2. Adding new rows prepared in Excel to the XML table
Example 3. Copy a part of an xml document to some other place
Example 4. Manipulate data nested inside a structure
Example 5. Create a table from csv file
Example 6. Remove table rows matching some criteria
Example 7. Split a bigger xml file then join fragments together

4. Manipulate data nested inside a structure

Let’s have a table which contains some nested data (in the picture it's a column "UnitName").
A table contains a complex element in a column

We want to add a new language data for the "UnitName" column. We have already prepared data somewhere...
Data preapred in excel for copy

For this purpose we use a function "SubTable" applied on the column "UnitName"...
Subtable command in a context menu

A column "UnitName" is displayed in a new form without the top horizontal level (if we need to manipulate data which are nested deeper we can call a sub-table repeatedly):
Subtable form

Now we can append a new column for this sub-table...
Append new element column in a subtable

...rename the column to 'cz-CZ', copy prepared data from Excel and paste them to this new column.
Paste data to a subtable column

A subtable with a new column

After that we close the sub-table, return back and we are finished.
A result with a new nested column inside structured data

Previous     Next