The Merge Rows (UNION) component merges two tables by row. If this component is used, the numbers and data types of the columns are the same in the two tables. This component integrates the features of UNION and UNION ALL.

You can configure the component only in the Machine Learning Platform for AI (PAI) console.
Parameter Description
Left 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 Similar to the WHERE clause in SQL statements, the WHERE clause you specified is used to filter data. Example: age>40.
Note Only the following operators are supported:
  • =
  • !=
  • >
  • <
  • >=
  • <=
  • like
  • rlike
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 Right Table Similar to the WHERE clause in SQL statements, the WHERE clause you specified is used to filter data. Example: age>40.
Note Only the following operators are supported:
  • =
  • !=
  • >
  • <
  • >=
  • <=
  • like
  • rlike
Remove Duplications Specifies whether to remove duplicate rows in the generated table. By default, this check box is selected, which indicates that duplicate rows are removed.