The Merge Rows (UNION) component merges two tables by row. This component integrates the features of UNION and UNION ALL. If this component is used, the numbers and data types of the columns must be the same in the two tables.
You can configure the component only in the Machine Learning Platform for AI (PAI) console.
Go to the pipeline page of Machine Learning Designer. Add a Merge Rows (UNION) component and connect it to upstream nodes. Click the component to configure the parameters.
Parameter | Description |
Left Table Output Column or Right Table Output Column | When you merge tables, the numbers and data types of the columns selected from the left and right tables must be the same. |
WHERE Clause for Left Table or WHERE Clause for Right Table | Similar to the WHERE clause in SQL statements, the WHERE clause you specified is used to filter data. Example: age>40. Only the following operators are supported:
|
Remove Duplicates | Specifies whether to remove duplicate rows in the generated table. By default, this check box is selected, which indicates that duplicate rows are removed. |