IMPORT QLIK QVD FILE

Category: Import / File

Description

This action loads data or metadata from a Qlik .qvd file.

Setting	Description
Load file^*	Fully-qualified file name of the Qlik .qvd data file (includes relative or absolute path).
Mode	Select which data is retrieved from the .qvd file. Options: Import data or Import metadata.

Setting	Description
Load only first^*	Check this option to limit the imported data to the first N rows (and enter or select the number of rows).
Load all columns	This option imports all columns in the file.
Load only selected columns	This option allows you to select which columns to import. A list of columns found in the .qvd file will be presented for you to select.

^* Setting can be specified using a parameter.

Setting	Description
File metadata	Check this to include metadata columns relevant to the .qvd file. Columns include: Created by, Modified (date), Column (count), Rows (count), File size, and Comment.
Column metadata	Check this to include column-specific metadata. Columns include: Field name, Unique values (count of), Is unique (T/F), Tags, Type, Format, and others.

Floating point values from .qvd files are converted into numbers with fixed decimal point in EasyMorph.

This action can import multiple files. See Importing Multiple Files for more information.

The structure of a QVD file is close to the internal data structure in EasyMorph. Therefore, reading QVD files in EasyMorph is very fast.

Fast ways to create the action:

Press the "Add data" menu button. Pick "Import file" or "Import multiple files".
Drag a Qlik file into the application window. Supported file extensions: .qvd
Drag a folder with Qlik files into the application window.