Structured file import

Tabular’s Structured File Import feature will automatically convert certain supported file types from the original data structure, format etc into the EIOPA format.

Currently the following file types are supported:
- Clearwater S(E).06.02, S.07.01, S.08.01, S.08.02, S.09.01
- Royal London Asset Management S(E).06.02
- T4U S(E).06.02
- Lombard Odier

To use this feature please follow these steps:

1. Click import in the ribbon and select structured import file.

Note only the first sheet in the source Excel file being imported will be considered by this feature. If your Excel workbook contains multiple sheets (eg S.06.02 and S.08.01 source data) these must be split into different workbooks and imported separately.

2. Select the file and the type of file to import in the pop up screen.

The file type must be the correct version of the QRT eg select Clearwater S.06.02 is importing into S.06.02, select Clearwater SE.06.02 for importing into SE.06.02
Further, please note that the Expected header row first column Excel address in the file must match the cell coordinate provided in the above window. If the first column header is not in that cell then the import process may not work as expected.

3. Choose the consolidate or overwrite option.
Consolidate will append the data imported below any existing data. Overwrite will remove any existing data and load the imported data from the first row in the Tabular QRT.

4. Once the above selections have been made click Import
The data should then be loaded into the relevant QRT worksheet(s). Note the import may load more than one worksheet may be populated in the Tabular return eg Clearwater and RLAM files contain data for S(E).06.02 table 1 and table 2 and both of these tables will be populated through the Tabular structured file import process.

Note, for some files (eg Lombard Odier) the source Excel file can contain multiple sheets, but the sheet names must be exactly the same as the QRT name in Tabular eg S.06.02.01.01 (S 06 02 01 01 as a sheet name will not be processed)