How to map tabular data

An example of mapping tabular data to XML file.

The component allows for mapping data that represents a table. An example of data containing tables may be provided by the RRTs generated by Professional Barcode component and representing barcode values for every page of a document.

Consider a configuration with Professional Barcode as a process component and XML Generator component.

In XML Generator configuration browse the following template.

Example:


<?xml version="1.0" encoding="iso-8859-1" ?>
<Root>
	<Document>
		<Page>
			<Number>Data</Number>
			<FirstBarcode>Data</FirstBarcode>
			<SecondBarcode>Data</SecondBarcode>
		</Page>
		<AllBarcodes>Data</AllBarcodes>
	</Document>
</Root>

Based on this template, set a configuration of the output file. First, multiply the Page node by inserting a counter m with Min value=1 and Max value=3.
Next, replace the Number node value with m, the FirstBarcode node value with ~FRB::m,1~, the SecondBarcode node value with ~FRB::m,2~ and the AllBarcodes node value with ~FRB::*,*~.

If the original document has 3 pages, with the first page containing 2 barcodes, for example, code1, code2, the second page containing no barcodes, and the third page containing 2 barcodes, for example, code3, code4, then the output XML file for this document is as follows:


<?xml version="1.0" encoding="iso-8859-1" ?>
<Root>
	<Document>
		<Page>
			<Number>1</Number>
			<FirstBarcode>code1</FirstBarcode>
			<SecondBarcode>code2</SecondBarcode>
		</Page>
		<Page>
			<Number>2</Number>
			</FirstBarcode>
			</SecondBarcode>
		</Page>
		<Page>
			<Number>3</Number>
			<FirstBarcode>code3</FirstBarcode>
			<SecondBarcode>code4</SecondBarcode>
		</Page>
		<AllBarcodes>code1, code2, code3, code4</AllBarcodes>
	</Document>
</Root>