zipload

Load data from a ZIP file.

This guide explains how to configure the zipload instruction. To learn about another instruction, go back to the Available custom script instructions overview.

Introduction

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

Creating a custom script transformation using the zipload instruction

To create and configure a custom script using the zipload instruction, follow these steps:

  1. Create a custom script transformation.

  2. In the Instructions step, select the zipload instruction.

  3. To configure the custom script instruction, 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 use within this custom script.

A subtable is a temporary table that 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.

If a subtable does not exist for the current custom script, the transformation is applied to the data extract, and the enriched data is output into the subtable. If the subtable already exists for the custom script, the subtable is used as the input for the transformation and optionally as the output.