Overview of Data Transformation

Added the Field-to-Column Splitting, Field-to-Row Splitting, and Group Summary operators.

4.1.3

When Data Source in the DB Table Input operator was set to DB Table Input:

• With Configuration Method set to Table Selection, you could select a source table for data synchronization and enable Parallel Read. 

• You could call stored procedures if the data source was a MySQL, Oracle, or SQL Server database.

4.1.6.4

Added the MongoDB Output operator, allowing you to output data to a MongoDB database.

4.1.11.3

Added the Elasticsearch Output operator, allowing you to output data to an Elasticsearch database.

4.2.0.2

Added the Elasticsearch Input operator, allowing you to fetch data from a specified Elasticsearch database.

Data Input

Allows you to fetch data from tables in relational databases.

For details, see Data Sources Supported by FineDataLink.

In V4.1.3 and later versions, when DB Table Input is selected as the data source type:

• With Configuration Method set to Table Selection, you can select a source table for data synchronization and enable Parallel Read. 

• You can call stored procedures if the data source is a MySQL, Oracle, or SQL Server database.

API Input

File Input

Jodoo Input

MongoDB Input

SAP RFC Input

Elasticsearch Input

Dataset Input

Allows you to fetch data from file datasets (Excel, TXT, XML, and CSV), tree datasets, stored procedures, programs, built-in datasets, and associated datasets. Among them, stored procedures, programs, built-in datasets, and associated datasets can only be defined in FineReport Designer.

Note:

The Dataset Input operator cannot fetch column values containing negative infinity (-∞) or positive infinity (+∞) from FineBI Public Data.

Data Output

DB Table Output

Allows you to output data into tables in relational databases.

Parameter Output

API Output

Jodoo Output

File Output

MongoDB Output

Elasticsearch Output

Connection

Data Association

Allows you to associate two tables from different source databases to generate a new table. The join methods are as follows:

• Left Join: Returns all records from the left table and the records where the join condition is met in the right table.

• Right Join: Returns all records from the right table and the records where the join condition is met in the left table.

• Inner Join: Returns only the records where the join condition is met in the two tables.

• Full Outer Join: Returns all records from both tables based on the join condition.

Data Comparison

Union All

Transformation

Column to Row

Allows you to convert the columns in a data table to rows.

Row to Column

JSON Parsing

XML Parsing

Field Setting

New Calculation Column

Data Filtering

JSON Generation

Field-to-Column Splitting

Field-to-Row Splitting

Group Summary

Laboratory

Spark SQL

Allows you to query and process data using the built-in Spark calculation engine where parameters and functions are supported.

Python

Others

Remark

Allows you to add remarks to tasks and nodes.