A table of raw data can be used for various reasons, and is a common way of exporting raw data for a subset of cases or variables in your data set. More specifically this feature allows you to view and export:
- Raw data to Excel using category labels instead of values.
- Text responses next to categories created via Text Categorization.
- Specific variables to review cases for quality.
- A raw data table for an Appendix in your Report.
- Raw data using a filter or show only a subset of variables of raw data.
Requirements
A document with a data set.
Method
1. Create a Page in your Report tree by hovering and clicking + > Page and select the page layout.
2. While on the Page, select the specific variables to export from your Data Sources tree that you want raw data for.
3. From the toolbar, click Table > Raw Data > Variable(s).
4. Click on the Page to place the output.
5. OPTIONAL: You can select more variables via the Object Inspector >Data > Variables field within the object inspector.
6. OPTIONAL: Nominal variables that have merged categories and aggregated Date/Time variables will display as such by default. To change this to only show the original categories and/or responses, go to Object Inspector > Data > Show Advanced Options > R Code > Edit Code, and delete
ProcessQVariables from line 5, then press Calculate.
7. OPTIONAL: If you have more than a million table cells, you will receive the following error message:
If you still wish to display your table, go to Object Inspector > Data > R Code > Edit Code, delete the lines shown below (lines 8 and 9), and press Calculate:
if (nrow(rawdata) * ncol(rawdata) > 1000000)
stop("Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.")8. OPTIONAL: Tick Object Inspector > Data > Variable names to replace variable set names with their individual variable names.
9. Go to Share > Export Report > Excel.
10. Select Export Selected from the Choose which pages/outputs to export dropdown.
11. Click Export.
UPCOMING WEBINAR: The Roadmap for Market Researchers in the Age of AI