join
Combine rows from 2 or more tables, based on a related column. A step-by-step.
The join directive executes an inner join with the "from" worksheet keyed on either the header names they have in common or the arguments, which come in pairs of first the "from" worksheet's header name and then the join worksheet's header name.
Joining worksheets can be used as a powerful alternative to searching. Users can quickly pair two related rows in two different worksheets into a single row in another worksheet.
Important Note
Worksheets you're joining should share at least a common column (if it doesn't have the same header name, join allows you to choose which columns you'd like to match)
Adding 'join'
Step 1: Click the "Add Directive" button on your dashboard
![1.png 600](https://files.readme.io/921954d-1.png)
Step 2: Choose "Join"
![2.png 600](https://files.readme.io/14e9c68-2.png)
Step 3: Select the worksheets you'd want
![3.png 600](https://files.readme.io/e62fd5c-3.png)
![4.png 600](https://files.readme.io/3f71066-4.png)
![7.png 600](https://files.readme.io/3b3fa4f-7.png)
With 'join', you would want to match columns. By default, Zen will match columns that have the same header name but we've also given you an option to choose your own pair(s) of columns if Zen can't find a matching column or simply if you'd like to choose your own pair(s) of columns.
![8.png 600](https://files.readme.io/3669297-8.png)
![9.png 600](https://files.readme.io/137aaa1-9.png)
![10.png 600](https://files.readme.io/e81612c-10.png)
Choose a column from the worksheet that'd you'd like to pair with
![13.png 600](https://files.readme.io/63160e3-13.png)
![14.png 600](https://files.readme.io/920f877-14.png)
Easily add another pairing
![15.png 600](https://files.readme.io/13c2427-15.png)
![16.png 600](https://files.readme.io/b89241d-16.png)
![17.png 600](https://files.readme.io/fff722d-17.png)
Easily remove the additional column pairing
Step 4: Once you're happy with your selection, click 'Next' and proceed to the next screen
![18.png 600](https://files.readme.io/cdf3fdb-18.png)
Step 5: Name your output worksheet
This will be where your output data from connecting the worksheet by adding 'join' will be.
![19.png 600](https://files.readme.io/ffd585a-19.png)
Step 6: Once you've inputted your output worksheet name, you're ready to add the directive!
![20.png 600](https://files.readme.io/c880e1a-20.png)
Voilà, success!
Your spreadsheet will automatically take you to the output worksheet. See the results of combining those worksheets you've choosen!
![22.png 600](https://files.readme.io/56c8a94-22.png)
![CleanShot 2022-06-16 at 14.26.08@2x.png 2880](https://files.readme.io/fa9a495-CleanShot_2022-06-16_at_14.26.082x.png)
What it'll look like on the spreadsheet
For more technical and in-depth information on our 'join' directive, do visit our Pebble Stream Enterprise Documentation
Updated about 2 years ago