Differences

This shows you the differences between two versions of the page.

--- transformations:importqlikview [2021/03/05 20:48] – craigt
+++ transformations:importqlikview [2024/04/12 00:11] (current) – include import metadata mode craigt
@@ Line 1: / Line 1: @@
 {{ transformations:ImportQlikViewAction.png}}
-======IMPORT FROM QLIK QVD FILE======
+======IMPORT QLIK QVD FILE======
-(Category: //Import | File//)
+Category: Import / File\\
+\\
 =====Description=====
-This transformation loads data from a Qlik .qvd file.
+This action loads data or metadata from a Qlik .qvd file.\\
-Note that floating point values from .qvd files are converted into [[syntax:types|numbers with fixed decimal point]] in EasyMorph.\\
 \\
 =====Action settings=====
-^ Settings  ^ Description  ^
+^ Setting  ^ Description  ^
-|Load file|Fully-qualified file name of the Qlik .qvd data file (includes relative or absolute path).|
+|Load file<sup>*</sup>|Fully-qualified file name of the Qlik .qvd data file (includes relative or absolute path).|
-|Load all columns|This option imports **all** columns in the file.|
+|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]]