Transformer, allows the user to automatically translate literals using the Bing machine translation.

Subscription key

This is the subscription key needed to access the Bing translator API

Default source language

The component takes input language from the input literal language tags. The default source language will be used for literals without language tags.

Target languages

Languages to which will the input literals be translated

Indicate machine translation in language tag

When switched on, the machine translation will be indicated in the target literal language tag using BCP47 extension T like this: "english string"@en-t-cs-t0-bing instead of simple "english string"@en

Transformer, allows the user to transform the RDF Chunked data unit into an RDF single graph data unit.

Transformer, allows the user to transform Microsoft Excel files to CSV files.

Output file name template

File name template under which the output CSV file will be visible in the pipeline, including extension. You can use {FILE} and {SHEET} placeholders to generate multiple CSV files from one input file

Sheet filter

Java regular expression matching Excel sheet names to process. If empty, all sheets are processed

Row start

Number of the first row to be transformed

Row end

Number of the last row to be transformed

Column start

Number of the first column to be transformed

Column end

Number of the last column to be transformed

Virtual columns with header

Adds sheet_name column header as this is currently the only supported virtual column

Determine type (date) for numeric cells

Excel stores dates and integers as double values. When checked, the transformer tries to parse these as dates and integers

Skip empty rows

When checked, empty rows are not included in the output CSV. Otherwise, they are full of NULL values

Add sheet name as column

When checked, a sheet_name column is added, with source Excel sheet name as a value

Evaluate formulas

When checked, formulas in Excel are evaluated

Transformer, which computes SHA-1 hash for each input file. The hash can be verified e.g. by the online calculator.

Transformer, decodes the input files using the base64 algorithm.

Transformer, allows the user to filter files by file name using Java regular expressions.

File name filter pattern

Regular expression to filter file names by

Transformer, allows the user to rename files by using Java regular expressions.

Full file name RegExp to match

Regular expression to match file names

Replace RegExp with with

Regular expression to replace the file names

Transformer, allows the user to convert RDF files (Files Data Unit) to RDF data (RDF data unit).

Commit size

Number of triples processed before commiting to database

Format

RDF serialization of the input file. Can be determined by file extension.

Transformer, allows the user to convert RDF files (Files Data Unit) to RDF data in chunks, to be processed in smaller pieces.

Format

RDF serialization of the input file. Can be determined by file extension.

Files per chunk

Determines, how many input files should be stored in one output chunk

Transformer, allows the user to convert RDF files (Files Data Unit) to RDF data in single graph.

Commit size

Number of triples processed before commiting to database

Format

RDF serialization of the input file. Can be determined by file extension.

Skip file on failure

When a file cannot be loaded, skip it instead of failing

Transformer, inserts contents of input files to RDF triple objects.

Predicate

The RDF triple predicate used in the triples containing the file contents as objects. The subjects are RDF blank nodes

Transformer, provides geographical projection transformation features using the GeoTools library.

Input resource type

IRI of the type of entities containing the geocoordinates, e.g. http://www.opengis.net/ont/gml#Point

Predicate for coordinates

IRI of the predicate connecting the entity of the input resource type to the literal containing the geocoordinates, e.g. the http://www.opengis.net/ont/gml#pos property. The geocoordinates format is "X Y", i.e. two xsd:double numbers separated by a space.

Predicate for coordinate reference system

IRI of the predicate connecting the entity containing geocoordinates to a literal containing the source coordinates reference system, e.g. http://www.opengis.net/ont/gml#srsName

Default coordinate reference system

Coordinates reference system to be used with entities, which do not specify the coordinates reference system themselves, e.g. EPSG:5514

Predicate for linking to newly created points

The new entity containing the transformed geocoordinates will be connected to the original entity using this predicate

Output coordinate reference system

Target coordinates type, e.g. EPSG:4326

Fail on error

Stops execution on error when enabled, continues execution when disabled.

Transformer. There are two types of RDF Data Units in LinkedPipes ETL right now. There is a data unit, that can contain multiple RDF named graphs, which is currently produced only by the Files to RDF, which may transform files containing RDF quads. When the user then wants to work with such data using components that only support triples, Graph merger is needed to do the conversion.

Transformer, allows the user to convert an HDT file (Files Data Unit) to RDF data (RDF data unit).

Commit size

Number of triples processed before commiting to database

Transformer, enables users to parse a HTML pages using jsoup CSS like selectors.

Class of root subject

IRI of the root output resource type

Default has predicate

Default predicate to be used to connect nested objects

Generate source info

Adds information about the source file into the output data

Transformer, performs JSON-LD operations on files formats using a JSON-LD processor.

Operation

Operation to be performed on input JSON-LD files

JSON-LD context (where applicable)

For Flatten and Compact operations, a new JSON-LD context can be specified

Transformer, adds a specified JSON-LD context and additional provenance data to input JSON files, making them JSON-LD.

Encoding

Encoding of the input files

Data predicate

IRI of the predicate connecting the root entity to the object representing the original JSON data interpreted as JSON-LD.

Root entity type

IRI of the type of the newly created root entity.

Add file reference

If checked, input file name is added to the output JSON-LD file using the File name predicate.

File name predicate

IRI of the predicate used to attach the input file name to the newly created root entity in the output JSON-LD file.

Context object

JSON object specifying the JSON-LD context.

Transformer, allows the user to add or subtract days from a date represented as xsd:date literal.

Input predicate

The predicate used in triples, where the object is the date to be shifted.

Shift date by

Number of days to shift the date by. Can be a positive and negative integer.

Output predicate

The predicate to be used in output triples to store the shifted date.

Transformer, generates text files using the {{ mustache }} template.

Entity class IRI

IRI of the RDF class of the objects, to which the {{ mustache }} template is applied.

Add the mustache:first predicate to first items of input lists

First items in input lists will have the mustache:first predicate added. This is useful for instance for generating JSON arrays, where we do not want to generate a comma after the last item of the array. This predicate can be used for this (we do not generate the comma before the first item).

Mustache template

The {{ mustache }} template

Transformer, generates text files using the {{ mustache }} template and works with chunked RDF data.

Transformer, allows the user to zip input RDF files (Files Data Unit) to an output zip archive.

Output zip file name

File name under which the file will be visible in the pipeline, including extension.

Transformer, allows the user to convert RDF data (RDF data unit) to an RDF file (Files Data Unit).

Output file name

File name under which the file will be visible in the pipeline, including extension.

Output format

RDF serialization of the output file.

IRI of the output graph

IRI of the only named graph that will be created from the input triples. Valid only for the RDF Quad formats.

Transformer, allows the user to convert chunked RDF data to an RDF file.

Output file name

File name under which the file will be visible in the pipeline, including extension.

Output format

RDF serialization of the output file.

IRI of the output graph

IRI of the only named graph that will be created from the input triples. Valid only for the RDF Quad formats.

Used prefixes as Turtle

Allows the user to insert prefixes declaration in Turtle format to be used in Turtle file output.

Transformer, allows the user to convert RDF data (RDF data unit) to an HDT file (Files Data Unit).

Output file name

File name under which the file will be visible in the pipeline, including extension.

Output base IRI

Base IRI for relative IRIs in the HDT file.

Transformer, allows the user to validate input RDF data using SHACL shapes.

Fail on rule violation

When on and a shape validation fails, the whole component, and therefore the pipeline, fails. When off, the failures are in the output report.

Shapes to apply (in Turtle)

An alternative way of providing the shapes graph. This is merged into the Shapes input.

Transformer, represents a union of RDF data. Useful to make nicer pipelines where multiple edges would have to be duplicated otherwise.

Transformer, allows the user to transform RDF data using a CONSTRUCT query. This means that based on the input data, output data will be generated using this query.

SPARQL CONSTRUCT query

Query for transformation of triples

Transformer, allows the user to transform chunked RDF data using a CONSTRUCT query. This means that based on the input data, output data will be generated using this query, preserving the data chunking.

SPARQL CONSTRUCT query

Query for transformation of triples

Transformer, allows the user to create multiple RDF files including multiple RDF named graphs using a set of SPARQL CONSTRUCT queries.

Use deduplication

Individual SPARQL query results may contain duplicate triples or quads. This is a result of the way the SPARQL queries are evaluated. For smaller files this causes no issues as the duplicates are correctly resolved when the resulting file is further processed. For larger files, it is possible to turn on deduplication, which processes the results when they are serialized. This causes a slight performance penalty.

Transformer, allows the user to transform chunked RDF data in combination with a smaller reference dataset using a CONSTRUCT query. This means that based on the input data and the reference data, output data will be generated using this query, preserving the data chunking.

SPARQL CONSTRUCT query

Query for transformation of triples

Transformer, allows the user to transform RDF data to a CSV file using a SELECT query.

SPARQL SELECT query

Query for transformation of triples

Transformer, allows the user to transform RDF data into multiple CSV files using multiple SPARQL SELECT queries.

Transformer, allows the user to transform RDF data using SPARQL UPDATE queries. This means that the input data will be changed - added to and/or deleted from.

SPARQL Update query

Query for transformation of triples

Transformer, allows the user to transform chunked RDF data using SPARQL UPDATE queries. This means that the input data will be changed - added to and/or deleted from, preserving the data chunking.

SPARQL Update query

Query for transformation of triples

Transformer, compresses input files using gzip or bzip2.

Format

Output compression format. Can be gzip or bzip2.

Transformer. Used to transform CSV files to RDF data according to the Generating RDF from Tabular Data on the Web W3C Recommendation. The first set of parameters is there simply do deal with CSV files not compliant with RFC 4180, which specifies a comma as a delimiter, the double-quote as a quote character, and UTF-8 as the encoding.

Transformer. Used to transform CSV files to RDF data chunks according to the Generating RDF from Tabular Data on the Web W3C Recommendation. This version of the Tabular component produces chunked RDF data for processing of a larger number of independent entities with lower memory consumption.

Transformer. Used to transform CSV files to RDF data. It is present only to allow smoother transition from UnifiedViews using the uv2etl tool. In all other cases, the CSV on the Web compatible Tabular component should be used instead.

Transformer, allows the user to transform Microsoft Excel XLS (not XLSX) files to CSV files using a template, which helps with print formatted files.

Template file prefix

Prefix used by template files. The part of the template file name after the prefix should match the original file name.

Transformer, allows the user to unpack input zip, bzip2, gzip and 7z files.

Unpack each file into separated directory

When checked, a directory will be created for each input file. Otherwise, all files will be decompressed into a single directory

Format

Input archive format. Can be zip, bzip2, gzip, 7z or auto, which means the format will be determined by the file extension

Skip file on error

When an error occurs with a file when processing multiple files, continue execution

Transformer, allows the user to unzip input zip files.

Unpack each zip into separated directory

When checked, a directory will be created for each input zip file. Otherwise, all files will be decompressed into a single directory

Transformer, allows the user to parse lists and other structured texts from a literal, creating multiple literals.

Predicate for input values

IRI of the predicate linking to the literal to be processed

Regular expression with groups

Java regular expression with named groups to match the items of the structured input text, e.g. (?<g>[^\[\],]+)

Preserve language tag/datatype

Sets the language tag or datatype of the input literal on the output literals

Group name

Name of the regular expression group to store as a new literal

Group predicate

IRI of the predicate linking to the output literals created from this regular expression group

Transformer, allows the user to transform XML files using XSLT.

New file extension

XSLT allows to create arbitrary text files from XML. Expecially for RDF files it is important that the new file has a correct extension according to its format

Number of threads used for transformation

The XSLT processor is given this number of threads to use for each transformation

XSLT Template

The XSLT template used to transform the input XML files