1. Using Pipeline Designer
  2. Managing Data Pipelines
  3. Widgets in Data Pipelines
  4. Creating Joins
  5. Join Operators

Join Operators

Join operators are used to join tables in the Output pane.

Join operators are used to join tables in the Output pane. The following types of join operators are available:
  • Inner Join:The Inner Join selects all rows from both participating tables as long as there is a match between the columns.
  • Left Join: The Left Join returns all rows from the left table, with the matching rows in the right table.
  • Right Join: The Right Join returns all rows from the right table, with the matching rows in the left table.
  • Full Join: The Full Join combines the results of both the left and right outer joins and returns all rows from the tables on both sides