User Tools

Site Tools


jvs:fscan:manual:chapter2:tablemerge

fScan Reference Manual, Chapter 2 (CmdLineOptions): table_merge

Table merge -- Merge data in two different tables

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:
Table, Browse

fScan Home, fScan Manual, CmdLineOptions, Manual Help

jvs/fscan/manual/chapter2/tablemerge.txt · Last modified: 2023/02/23 18:43 (external edit)