KeyValueToTuple operator

This operator can be used to translate a key-value/json object to a tuple.

Names are JSON-Path Exceptions

If names contains special chars like ".", "*", etc. the chars will be replaced by "_".

To define own names you ['Path','Name','Type'] in the schema.

Parameter

• schema: The list of requested attributes (keys) and their data type.

• type: The type of the output tuple
• keepInput: If set to true, the key-value is stored in the additional content container of the output tuple.
• dateFormat: Can be used to format the timestamp. To create a timestamp an attribute of data type STARTTIMESTAMP or ENDTIMESTAMP has to be added to schema.

Example

out = KEYVALUETOTUPLE({
          schema=[['Name', 'Double']],
          type='Measurement',
          keepinput='false' 
        },
        in
      )

Example 2

Assume that a data source in sends key-value-pairs about persons in the following (JSON-)format: 

{person.name="Max", person.age=22, timestamp=11123}

Then, reading the name (and timestamp) is as follows:

out = KEYVALUETOTUPLE({
          schema=[['person.name', 'String'], ['timestamp', 'STARTTIMESTAMP']],
          type='Measurement',
          keepinput='false' 
        },
        in
      )