Desktop User Guides > Professional > Data management scripting > Working with UNICOM Intelligence Interviewer - Server data > Restricting the variables in the export
 
Restricting the variables in the export
You might want to export only a subset of the variables in your project, for example, only certain key variables. Filtering data in a DMS file describes how you can set up a metadata filter in your DMS files to restrict the variables included in the export. However, sometimes you might want to restrict an export to variables of one type, such as categorical or text variables. The UNICOM Intelligence Developer Documentation Library includes two sample .mrs files that are useful when you want to do this. You can change these samples to select variables of different types.
Both samples create a SELECT statement containing Respondent.Serial and all of the variables of the specified type. You can copy the SELECT statement in the text file and paste it into your DMS file. You can delete the names of any variables of the specified type that you do not want to include. Alternatively, you can use the text file as an Include file. The mrInterviewCategoricalsOnlyToDDF.dms sample shows how to dothis. For more information, see Sample DMS files for exporting UNICOM Intelligence Interviewer data. The CategoricalsOnly.bat sample shows how to run the two files. For more information, see Sample batch files.
ListCategoricalVars.mrs
This writes the full name of each categorical variable instance to a text file in a form that can be copied and pasted straight into the select query in a DataManagementScript (DMS) file.
ListOpenEndedVars.mrs
This writes the full name of each text variable instance to a text file in a form that can be copied and pasted straight into the select query in a DataManagementScript (DMS) file.
For more information, see Sample mrScriptBasic files.
See
Working with UNICOM Intelligence Interviewer - Server data