id: version-0.66.0-org.apache.streampipes.processors.transformation.jvm.csvmetadata title: CSV Metadata Enricher sidebar_label: CSV Metadata Enricher original_id: org.apache.streampipes.processors.transformation.jvm.csvmetadata

Enrich a datastream with information provided in a CSV file. The data of the CSV file is matched by an id column with a property value of a String in the data stream.

Description

Upload a CSV file with static meta information that will be appended to each event. The file can contain different information for different keys in the stream.

Structure of CSV file

The first row containes the runtime names for the properties to insert. Once the file is uploaded the user can select which column to use for the matching property and which values should be appended. Delimiter: ‘;’

Example

Add the location of a production line to the event

Input event

{
  'line_id': 'line1', 
  'timestamp': 1586378041
}

CSV File

production_line;location
line1;germany
line2;uk
line3;usa

Configuration

  • The field that is used for the lookup (Example: line_id)
  • The CSV file (Example: Upload the csv file)
  • Field to match (Example: production_line)
  • Fields to append (Example: location)

Output event

{
  'line_id': 'line1', 
  'timestamp': 1586378041, 
  'location': 'germany'
}