zipload

Load data from a ZIP file.

Introduction

Use the zipload enrichment to load data from a ZIP file.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Filemap

By default, data from all files contained in the ZIP archive is loaded to the same table.

To specify a subtable for each file's data, follow these steps:

1. Click +.

2. In the field on the left, specify the name of the subtable.

3. In the field on the right, specify the name of the file.

4. Repeat the procedure above for each file contained in the ZIP archive.

As a result, data from each file contained in the ZIP archive is loaded to the specified subtable.

Format

Specify the file format.

Subtable

Enter the name for a subtable that you want to contain the enriched data. The enrichment is applied to the whole data extract, then the enriched data is output into the subtable you have named here.

This subtable is a temporary table, which means it only exists for this custom script. You can apply additional instructions within the same custom script to the subtable. However, the subtable cannot be used in any other custom scripts.