Meta Data (Imports)
-
What Is Meta Data?
Meta data is all information regarding the data, except the numbers or text which can be referred to as the data itself. When we refer to meta data, think ab...
-
Can I Change the Meta Data During the Import?
Creating new Meta Data Transformation (MDT)Metadata transformation enables you to change meta data, assign mandatory variables to your file and apply the sam...
-
How to Create a RespondentID?
The data import expects the mandatory variable to identify the respondents. If the variable is named “Respondent Id” the system will automatically detec...
-
How to Create a Respondent Date?
When using the built-in functions for a time series, the ResponseDate is used as a base in the calculations. The data import expects the mandatory variable t...
-
How to Convert a String into a Date Variable?
The Meta Data Transformation Tool can convert a String variable to a Date variable. To transform a String variable when metadata transformation opened place ...
-
How to Create a Weight Variable?
The import expects a variable to identify the weight on each respondent. If the data is un-weighted, the value “1” should be applied to all respondents. If t...
-
How to Inactivate Variables During the Import?
Metadata transformation provides option to exclude variables from the import, that you don’t want to show in your reports. You can also select several variab...
-
How to Group Multiple Choice Variables?
This option will visually group all multiple-choice questions into one individual multiple-choice question with answers, rather than one row per answer. The ...
-
How to Change Question Codes (Variable Names) and Labels?
In case you need to change the Question code or Question text, use the built-in function which you can find in metadata transformation menu. A short label co...
-
How to Quickly Identify Errors in Your Datafile?
In the meta data transformation screen filters have been added to the column headers which makes it easier to for example find the errors as shown in the ima...
-
How to Move the Question Text to the Answer Text?
Use this function when you need to overwrite the existing value label with your variable label. This is especially useful in multiple-choice questions that s...
-
Copy Question Answer Code to Empty Question Answer Texts
The import expects there to be value labels on each value, or else it will reject the file. If the value labels are missing some values, you can use this fun...
-
Fix Duplicate Answer Labels
The metadata transformation will validate if any answers are duplicated within a question. Note the behavior is different when you made changes:If you didn'...
-
How to Reuse Meta Data Transformations?
Once you are done transforming the metadata structure, you can save this transformation and apply it to all future data-loads. You can either overwrite or sa...
-
How to Recode String into a Categorized Question?
If data is imported through the Excel/CSV format this function can be used to create Categorical variables from String or Numeric variables. The recoding is ...
-
How Are Answer Blocks Created During a First Import? (Logic)
Rule A: Questions with identical answer texts and answer values will share an Answer Block. (see example 1) Rule B: Questions with different numbers of answ...
-
How Are Answer Blocks Created During Additional Imports (Logic)
The additional meta-data imports are performed when new questions or answer alternatives need to be added to a project. The following rules are applied durin...