Table of Contents

IMPORT QLIK QVD FILE

Category: Import / File


Description

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


Action settings

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


Import data settings

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 columnsThis option imports all columns in the file.
Load only selected columnsThis 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.


Import metadata settings

Setting Description
File metadataCheck 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 metadataCheck this to include column-specific metadata. Columns include: Field name, Unique values (count of), Is unique (T/F), Tags, Type, Format, and others.



Remarks

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.


Shortcuts

Fast ways to create the action:


See also