{{ transformations:ImportQlikViewAction.png}}
======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<sup>*</sup>|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//.|

\\
====Import data settings====
^ Setting  ^ Description  ^
|Load only first<sup>*</sup>|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.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\
====Import metadata settings====
^ 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. |


\\ \\ 
=====Remarks=====
Floating point values from .qvd files are converted into [[syntax:types|numbers with fixed decimal point]] in EasyMorph.

This action can import multiple files.  See [[import:fileimportmodes|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:
  * 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.

\\ 
=====See also=====

  * [[transformations:exportqlikview|Export into Qlik QVD file]]
  * [[transformations:qlikcloudcommand|Qlik Cloud command]]
  * [[transformations:qliksensecommand|Qlik Sense command]]