ToolValueLookup

<p>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:</p><p><strong>Customer Info</strong>: Match customer IDs in the data table with a dictionary of customer names and emails. The tool adds name and email to each row.</p><p><strong>Product Lookup</strong>: Match product codes from sales data with a dictionary of descriptions and prices. The tool appends product details.</p><p><strong>Region Mapping</strong>: Match ZIP codes with a dictionary of regions. The tool adds region and territory info to each row.</p>