Skip to main content Skip to complementary content
Qlik Resources

Creating and managing custom ETLs

You can create and manage Pre and Post Loading ETLs as described in the table below.

Information noteCommon Table Expressions (CTEs) are not supported as well as some special clauses.
ETL actions
To Do This

Define a Pre Loading or Post Loading ETL
  1. Select either the Pre Loading or Post Loading tab as appropriate.

  2. Click the New button above the User Defined ETL column.

    The Add New Pre/Post Loading window opens.

  3. Specify a name for the ETL and then click OK.

    The name is added as a link to the User-Defined ETL column.

  4. Click the link.

    The Edit ETL Instruction: Name window opens.

  5. To define an ETL:

    1. Select a table and/or column and click the arrow to the right of the selected table/column to add it to the ETL.
    2. Use the Select, Delete, Insert and Update quick access buttons at the top of the window to add SQL statements to your ETL.
    3. To save your ETL, click OK.
    4. To enable/disable the ETL, select or clear the check box to the left of it as required.

Rename a Pre Loading or Post Loading ETL
  1. Select either the Pre Loading or Post Loading tab as appropriate.
  2. At the end of the row containing the ETL name click the Rename button (A).
  3. Rename the ETL and then click OK to save the new name.

Edit a Pre Loading or Post Loading ETL
  1. Select either the Pre Loading or Post Loading tab as appropriate.
  2. At the end of the row containing the ETL name click the Edit button.
  3. Edit the ETL as described in Step 5 of Define a Pre Loading or Post Loading ETL.

Updating custom ETLs

Information note

Compose CLI requires Administrator permission. To grant Administrator permission, select "Run as administrator" when opening the command prompt. All commands should be run from the Compose bin directory (C:\Program Files\Qlik\Compose with a default installation).

You can update custom ETLs using the Compose CLI. This functionality can be incorporated into a script to easily update Custom ETLs.

Syntax:

composecli update_custom_etls --project name --infolder path

Where:

  • project is the name of the project with the custom ETLs you want to update
  • infolder is the full path to the folder containing the custom ETL files

Example:

composecli update_custom_etls --project my-project --infolder c:\Compose\CustomETLs

Warning noteThe file names in the input folder must be identical to the custom ETL names in the specified project. Otherwise, an error will occur. The file extension (for example, .txt) is not important, but the file must be in SQL format.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here