Output to QlikView / Sense - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Outputs Data360 Analyze data to the Qlik QVX file format, allowing users to work with the output data within the Qlik Sense and QlikView applications.

QVX formatted file

A QVX formatted file contains metadata followed by actual data.

The metadata is stored as an XML formatted table header written in UTF-8 character set. The header describes the fields in the table, the layout of the subsequent data together with some other metadata. The fields in the table comes from the fields in the input data pin.

The actual data are formatted according to the table header. The actual data are stored as ASCII or binary, depending on the data types.

Supported data types

Supported BRD data types are String, Long, Double, Integer, Boolean, Unicode, Date, Time, and Datetime. The node will transform each of these data types to the corresponding QVX binary types.

Notes

1. Boolean values "True" and "False" will be transformed to integral values of 1 and 0 respectively.

2. The node handles NULL input values by not passing any field values to the corresponding table field in the file.Example. If input metadata has a field "myDatetime" of type datetime, and record 10 contains a NULL value, row 10 of the QVX table will not contain any value for that field.

3. For data types of string and unicode, although the node writes different binary representations for empty strings and NULL values to the file, such values look the same when they are viewed using the QlikView application.Example. If input metadata has a field "aString" of type string, and record 1 contains a NULL value, record 2 contains an empty string, and record 3 contains a space. The node will record three different binary representations for such values. However, when QlikView application is used to view the output file, the three rows look the same.

Properties

OutputFilename

Click the folder icon and browse to the QVX output file to which you want to export the data in QlikView and Qlik Sense format, then click Choose.

To create a new file, click the folder icon and navigate to the folder where you want to output the file, then enter a name for the file in the Filename field and click Choose.

A value is required for this property.

Note: If you are using the server edition, the output file will be created on the Data360 Analyze server. If you wish to open the file, and you don't have access to the file system on the server, you will need to download the file onto your local machine. Please see the topic Downloading data from the server for more details.

MaxRecords

Optionally specify the maximum number of records in the input to be output to QVX file.

If 0 is specified, all records will be converted.

The default value is 0.

OutputFileExists

Optionally specify how to handle an existing QVX output file. Choose from:

  • Error - The node will throw an error if the QVX output file exists.
  • Ignore - The node will overwrite the existing QVX output file.
  • Log - The node will note the QVX output file exists in the log and overwrite.

The default value is Error.

Inputs and outputs

Inputs: indata.

Outputs: None.