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.
- Enrich the data from one worksheet with data from another sheet
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.
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.
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
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.
Questions and Feedback
Last Updated: 11/27/17