Differences

This shows you the differences between two versions of the page.

--- jvs:fscan:manual:chapter2:tablemerge [2014/03/24 15:53]
voyvodic created
+++ jvs:fscan:manual:chapter2:tablemerge [2023/02/23 18:43] (current)
@@ Line 1: / Line 1: @@
 **fScan Reference Manual, Chapter 2 (CmdLineOptions): table_merge**
-===== Table merge -- =====
+===== Table merge -- Merge data in two different tables=====
-**usage: -table [file] TABLENAME [FLAG] FILENAME**\\
+**usage: -table merge TBLNAME FLAG TBL2NAME MERGECOL**\\
+This command will merge rows of data from table TBL2NAME into table TBLNAME, based on the value of column MERGECOL.  MERGECOL must exist in both tables. Values in MERGECOL should be unique within each table.
+FLAG:
+  * 1 - copy rows in TBL2 to TBL (default)\\
+  * 2 - delete row in TBLNAME if not found in TBL2NAME\\
+  * 4 - inverse flag; if copying, copy rows in TBL2 not found in TBL.
+If deleting, delete rows in TBL if not found in TBL2.
 **See Also:**\\

Brain Imaging & Analysis Center