Template Overview
A template in Bordereaux is a project container where you manage your data throughout the cleanup process. The Mapping Template Manager provides tools to build a linear set of actions to produce a bordereau output at its conclusion.
The tabs shown below represent the progression of refinement as the data progresses through the process. When your bordereaux project includes multiple input files, an additional tab is available for establishing links between the files before bringing the data into the system.
The image above shows the series of tabs that comprise an executable set of actions that process data for ETL In computing, extract, transform, load is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source or in a different context than the source. - Wikipedia or for bordereaux.
![]() |
All fields brought into the system must first exist in Master Data Setup. The Master Data Setup is where you essentially create the data dictionary for your project. See the Master Data Field Reference for more information. |
Each tab in the Mapping Template Manager is one stage of executable program that when run with you data, will transform raw data into a bordereau report or another output type you designate.