Show/Hide Toolbars

EmEditor Help

Navigation: EmEditor Help > Dialog Boxes

EmEditor Dialog Boxes: Join CSV dialog box

Scroll Prev Top Next More
EmEditor Home - EmEditor Help - Dialog Boxes

Join CSV dialog box

This dialog box appears when the Join CSV command or the Join CSV button is selected in the CSV/Sort toolbar.

CSV Document 1 drop-down list box

Selects the first document.

CSV Document 2 drop-down list box

Selects the second document. The two CSV documents will be merged using values in the key column common to each document.

Key Column drop-down list box

Selects the key column.

Unique Key check box

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.

Include all non-matching rows check box

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.

Match Case check box

If this is checked, EmEditor uses case sensitive comparisons when checking the value in the key column.

Simply Merge (No Keys) check box

If this is checked, EmEditor simply merges two documents without using keys.

CSV Document/Column list box

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.

Enable/Disable All check box

This check box allows you to enable or disable all items in the list.

Up button

Moves the selected item(s) up on the list.

Down button

Moves the selected item(s) down on the list.

Export button

Exports the current settings into a JavaScript or VBScript macro file. An exported macro file can be used to run the same operation.

Join Now button

Starts merging the documents.

Copyright © 2003-2018 by Emurasoft, Inc.