User Tools

Site Tools


transformations:importqlikview

Differences

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

Link to this comparison view

Next revision
Previous revision
Last revisionBoth sides next revision
transformations:importqlikview [2015/01/31 15:02] – created dmitrytransformations:importqlikview [2024/04/11 23:58] – [Description] craigt
Line 1: Line 1:
-===== Import from QlikView QVD file =====+{{ transformations:ImportQlikViewAction.png}} 
 +======IMPORT QLIK QVD FILE=====
 +Category: Import / File\\
  
-This transformation loads data from an QlikView QVD file.+\\  
 +=====Description=====
  
-File name should include full or relative path.+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).| 
 +|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]].\\ 
 + 
 +\\  
 +=====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/importqlikview.txt · Last modified: 2024/04/12 00:11 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki