Tool - Value Lookup
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.