Open topic with navigation

# Create the Sub Table Template File

This section describes how to create the sub-table template file. This template file defines how the information extracted from the `Items` and `Products` table is structured.

When the connector runs the fetch task, this template is combined with the main template and used to generate a single document for each row returned from the main table (`orders`).

To create the sub-table template file

1. In a text editor, create the sub-table template for data extracted from the `Items` and `Products` tables:

       ITEM <!--ProductID-->, <!--ProductName-->, QTY <!--Quantity-->, £<!--Price-->

   Each HTML comment in the sub-table template is replaced by data extracted from the corresponding column (`ProductID`, `ProductName`, and so on) from the joined `Items` and `Products` tables.

2. Save the file as `items.tmpl` in the connector's installation folder (the file name you specified in the configuration file).

© Copyright 2018 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm