User Tools

Site Tools


transformations:exportqlikview

EXPORT INTO QLIK FILE

Category: Export / File


Description

This action exports the current table into a Qlik .qvd file.


Action settings

Setting Description
File* The fully-qualified file name of the output dataset (includes relative or absolute path).
Table name* Enter a name for the table in the output file.
File already existsIf a file with the same name already exists, choose whether to overwrite the existing file, rename the
existing file, or halt the action's execution. See the "File already exists options" table below for details.
Generate LOAD StatementOnce the File name has been entered, clicking this button will generate a Qlik LOAD statement that can be copied to the clipboard.

* Setting can be specified using a parameter.


File already exists options

Option Description
OverwriteThe new file replaces the original file.
RenameThe original file will be renamed with "backup" and a serial number appended to the file name. The new file will
possess the name specified in the File setting.
Halt project executionThe project will stop processing and this action will display a warning symbol.


Remarks

The table name specified in the output QVD file can be specified explicitly, otherwise, the name of the table that contains the action will be used.

Note that numbers in EasyMorph are converted into floating-point values in QVD files which may potentially lead to a loss of precision as numbers in EasyMorph allow more digits after the decimal point.

The structure of a QVD file is close to the internal data structure in EasyMorph. Therefore, writing QVD files in EasyMorph is very fast.


See also

transformations/exportqlikview.txt · Last modified: 2021/05/14 04:47 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki