Skip to main content

Row Concatenation

1. Function Description

Business data of the same type may come from different subsidiaries, stores, and even within the same organization, there are datasets from different data sources. For example, supermarkets have multiple payment methods: cash, UnionPay, mobile payment, etc., resulting in decision makers and IT departments having numerous data sources at the end. Row concatenation can combine data from different sources of the same business together.

2. Operation Steps

  1. Drag the Row Concatenation operator from the data flow operator area into the right canvas editing area.

  2. Drag the datasets to be row concatenated into the canvas and configure row concatenation.

    As shown in the figure below, there are two datasets from different sources, but the fields are completely identical.

    As shown in the figure below, when performing row concatenation, you can choose the column retention situation, such as retaining all columns, only retaining common columns, or saving all columns of any dataset.

  3. After obtaining the concatenation result, you can click on the number under a certain dataset in the upper left area to view which fields are retained for the corresponding dataset.