Differences

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

--- transformations:importqlikview [2024/04/11 23:58] – [Description] craigt
+++ transformations:importqlikview [2024/04/12 00:11] (current) – include import metadata mode craigt
@@ Line 12: / Line 12: @@
 ^ 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.|
@@ Line 17: / Line 22: @@
 <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.
@@ Line 36: / Line 48: @@
   * [[transformations:exportqlikview|Export into Qlik QVD file]]
+  * [[transformations:qlikcloudcommand|Qlik Cloud command]]
+  * [[transformations:qliksensecommand|Qlik Sense command]]