Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Defining dynamic schema columns

Last updated: 9/24/2025
The dynamic schema columns are easy to define. To define dynamic columns for the Databases Input and Output components, or for tFileInputDelimited and tFileOutputDelimited.

Procedure

  1. In the component's Basic settings tab, set the Property Type as Built-In.
    Information noteWarning: The dynamic schema is only supported in Built-In mode.
  2. Click Edit schema to define the schema.
    The Schema dialog box opens.
  3. In the last row added to the schema, enter a name for the dynamic column in the Column field.
    Information noteWarning: In the Database Input components, the SELECT query must include the * wildcard, to retrieve all of the columns from the table selected.
  4. Click the Type field and then the arrow which appears to select Dynamic from the list.

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 – please let us know!

Leave your feedback here