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.
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.