Merge

Merge takes data from a source Text file or Data file and writes it to the fields in a Target file based on one or two matching key fields. Typically, it is used for such tasks as merging data from a Laboratory Assay file into an existing file. In such a case, the sample number would be used as the key.

Text (ASCII) files must be column delimited. The function will not work with comma or tab delimited files. If the file containing the data you require for the merge is not column delimited, import it into the program and use the Merge | Text function on the File tab, in the Actions group.

Whether you are merging a Text file or a Data file, the Target file is always the file which is open in the active window of the File Editor.