Join

Join lists

Join list a with list b where c matches

list[].attribute1
list[].attribute1
list[].attribute2
list[].attribute2
list[].attribute3
list[].attribute3

This building block is the Swiss Army knife tool for processing and combining structured data. You can for example combine different sheets, listed files, contacts or any other structured data available.

Use cases

  • Enrich the data from one worksheet with data from another sheet

Configuration

Click on the bold text in the title of the building block to open the configuration dialog.

 After adding the script to your flow, click on the keyboard icon in the input parameter section.

Useful combinations

Example: You have a list of items in your first sheet called items and a price list in the second sheet called pricelist. If you now want to print your list of items and also want to display the price for each item you can merge the data from the price list into your items table.

Enter items as main table and pricelist as table to be merged into the main tables.

Then specify the condition how to find matching rows in the secondary table.

Let's say you have column called id in the items sheet and a column called productId in the pricelist sheet. The condition to find the matching rows then looks like this:

row1['id'] == row2['productId']

As we want to print the items table with additional columns from the pricelist sheet, we use items as the name of the merged table.

You can also apply filters and calculations on each row in the same way you know if from the Filter rows and Calculate columns scripts.

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 27.11.17