Join

Join lists

list[].attribute1

list[].attribute2

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.

Only unbound input parameters are activated in the form dialog, so if you are using the script multiple times you may need to activate the table and expression parameters.

The merged tables do not show up in the Ultradox Template Editor as the table structure is created at run-time. You'll have to enter the variables for the merged columns by hand when creating your template.

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.

Please note that you will have to access the columns by using the row1 and row2 prefix to distinguish the tables

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.