This guide will give help you learn how to configure the Join operation for joining data from two data sources.

Configuration

To join data from two data sources, please follow these steps:

1. Drag-and-drop the source and target connectors to Apatar's work panel.
2. Drag-and-drop the Join operation node, as well.
   
   
   
   
3. Configure the connectors.
4. Map all the nodes together.
   
   
   
   
5. Double-click on the Join node to set its properties. The Join window will pop up.
6. Now you need to define the fields that will represent the criteria for joining the source tables. Switch to the Join on tab page, please.
7. Press the "+" button to set a new condition.
8. Now, choose the necessary fields. Please note that the fields in both of the two input tables must contain equal values.
   
   
   
   
9. Now switch back to the Work tab page.
10. Press the "Input Table1" layer in the left column. You will see the fields of the first source table.
11. Drag-and-drop all the fields you want to transfer from the source to the target into the Join's work area (on the left).
12. As well, drag-and-drop the output fields from the target table (on the right).
13. Map all of the corresponding fields together.
    
    
    
    
14. Now switch to another source table layer, "Input Table2".
15. Drag-and-drop the fields you want to transfer from the second input table.
16. Map them with the corresponding target fields.
    
    
    
    
17. Click "Ok".

Now you can preview the Join results or run the transformation.

Preview

To preview the output data, right-click on the Join node and choose "Preview Results". If all of the previous actions were performed correctly, you will see the output entries.

To run the transformation, either choose Run from Apatar's File menu, or right-click on the output connector and choose "Preview Results".