Join

Overview

the join app is an app that joins datasets together into a single set, akin to the join that occurs in a relational database. The app generates the join by creating a script that executes the specified join. The join can be added to your workspace by adding the script.

Join API

The join application uses the join api to perform its joins.

Joining Datasets

When joining two datasets (note, they can be same dataset), you need to specify the following information.

• both datasets
• the keys to use in the join (that is, which columns in the data to join on)
• how to construct the resulting record from the two joined records

Specifying Datasets: Choose a dataset from the select data drop down box. Then click either the "add left" button or the "add right" button to specify which dataset you have chosen. Once you click the button, the dataset is set and its name will appear above the left or right keys.

Specifying Keys: After choosing a dataset, you need to specify the join keys. When you select a dataset in the select data drop down, its columns will appear in the column drop down. To add a column as a key, click the add left key or add right key button. The column will be added to either the left keys or right keys set. Note, you can specify both datasets before choosing keys. When you change the data drop down, its columns will appear in the column drop down.

Note, you need the same number of keys for each dataset, and the order matters. To remove a key, check the checkbox next to the key you wish to remove, and click the remove key button.

Gallery