ToolValueLookup

Value Lookup Tool

This tool enriches a data table by matching values from a reference (dictionary) table. You provide two tables: the data table to be enriched and the dictionary table with reference info. Choose one column from the data table and one from the dictionary table to match on. When a match is found, all columns from the matching dictionary row are added to the data row. Examples:

Customer Info: Match customer IDs in the data table with a dictionary of customer names and emails. The tool adds name and email to each row.

Product Lookup: Match product codes from sales data with a dictionary of descriptions and prices. The tool appends product details.

Region Mapping: Match ZIP codes with a dictionary of regions. The tool adds region and territory info to each row.

❗ To be copied to the workflow description

Configuration

Configuration nodes The values that can be setup by the agent.

Input data

Zero, one or more input data tables

Test data

To be used during development

Message

String message for the calling agent.

Output data

Zero, one or more output data tables