EmEditor features the join operation to combine two CSV tables. A join operation in SQL uses key columns to merge values of two tables into a single table. This allows you to associate records from one table to those of another. The Join CSV dialog box is accessed through CSV | Advanced | Join….
The documents to join and their key columns are specified. There are many conditions to match the key values with, including string equality, substring (partial string) match, prefix, and suffix match. The columns of the result table can be moved around.
Here are two tables that were joined using Join CSV.
The tables were joined using the item code column.