Administrative functions > Creating and maintaining Quanvert databases > Adding new or amended variables to a database > Using the Quanvert Text merge program
 
Using the Quanvert Text merge program
Quick reference
To merge variables into an existing Quanvert Text database, go to the directory containing those variables and type:
qvmerge [–xaxes] [–inums] [–palpha_vars] [–llevels] database_path
database_path is the pathname of the database directory into which the variables are to be merged. Pathnames may be absolute or relative.
The qvmerge program is distributed as part of Quanvert Text.
More information
To merge new or replacement axes or variables into an existing Quanvert Text database, flip the variable definitions against the original Quantum data as described above. You will then have pairs of axis and data files for each new axis or variable.
If there are no parameters, then all variables are merged.
As it merges variables, qvmerge updates the seg1.qv, wmvals and qvlv files with information about the new variables.
If the command line includes parameters, only the variables named by those parameters are merged. You can enter lists of names by separating the names with commas (a space indicates a new parameter).
To merge all variables for which there are no parameters (for example, only named axes but all numeric and text variables), use the notation -x+, -i+ or -p+ as appropriate (for example, –i+ to merge all numeric variables).
In levels jobs, only axes and variables at the named levels are merged; if you omit the -l, all levels are assumed.
For example, to merge new files from /usr/qt/barbara/temp into the database in /usr/qt/quanvert/summary, type:
cd /usr/qt/barbara/temp
qvmerge /usr/qt/quanvert/summary
Examples
These examples assume that the files to be merged are in the current directory and that the database directory, myproj, is a subdirectory of the current directory.
The first command merges just the axes age, sex and mstat into the database. Since there are no other parameters on the command line, all numeric or text variables, and any other axes in the current directory are ignored:
qvmerge -xage,sex,mstat myproj
The next example merges the axes age, sex and mstat, and all numeric and text variables. If there are no numeric or text variables, or you name a non-existent axis or variable, a warning is issued:
qvmerge -xage,sex,mstat -i+ -p+ myproj
The next command merges all variables at household level:
qvmerge -lhhold myproj
The next command merges axes at household or person level which are called income. All other axes and variables at those levels are ignored, as are all axes and variables at other levels:
qvmerge -lhhold,person -xincome myproj
See also
Adding new or amended variables to a database