Merge tables
Purpose of this building block
The Merge tables 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.
Possible use cases
- Enrich the data from one worksheet with data from another sheet
Configuration
Click on the reload icon to scan the Google Form for modified, added or removed fields.
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 guide, feel free to add them 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:
