This dialog box appears when the Join CSV command or the Join CSV button is selected in the CSV/Sort toolbar.
Selects the first document.
Selects the second document. The two CSV documents will be merged using values in the key column common to each document.
Selects the key column.
If each line in the key column contains a unique value, the key column is a unique key colulmn, and this check box can be set to optimize the speed of the Join operation.
Includes all non-matching rows when merged. This is equivalent OUTER JOIN in SQL if both check boxes are checked, LEFT JOIN if only the left check box is checked, RIGHT JOIN if only the right check box is checked, and INNER JOIN If neither is checked.
If this is checked, EmEditor uses case sensitive comparisons when checking the value in the key column.
If this is checked, EmEditor simply merges two documents without using keys.
The list is filled with all the columns in both documents. You can check only the columns that you want to include in the output, or change the order to change the colulmn order in the output.
This check box allows you to enable or disable all items in the list.
Moves the selected item(s) up on the list.
Moves the selected item(s) down on the list.
Starts merging the documents.