When to use Enrich one file with another?
Direct entry into Join mode of “Compare & reconcile data”: enrich A rows with B columns using a controlled key, then export CSV or XLSX.
- Add department/category data from a reference file
- Enrich an HR/CRM export with attributes from another file
- Replace a one-off XLOOKUP/VLOOKUP without opening Excel