Importing Crosstabs

Overview

Import is used to copy one or more crosstabs and their associated charts from a source dataset into a similar target dataset. Because crosstabs are built upon variables, a successful crosstab import depends on the presence of those variables within both datasets.

Note: MarketSight will generate an "Import Log" in the Tasks area, located in the upper-right corner of the application. This is an Excel workbook that summarizes the results of the import, and it contains the reason why an item may not have imported successfully. If you need assistance understanding the import log, please contact Customer Service.

Import From Another Dataset

  1. Load the dataset you would like to import to
  2. Click on the Import button on any list page
  3. Click on the Select Dataset button
  4. Select the old dataset you would like to import items from
  5. To import everything from the source dataset, check the box next to Select All, or
  6. To import only certain types of items, check the box next to the appropriate item type, or
  7. To import only certain items within each type:
    1. Expand each type by clicking on the plus sign to view a list of individual items
    2. Select the items to import

What "Only Import Exact Matches" Means

"Only Import Exact Matches" means just that - if the variable codes, labels, values and value labels are an exact match in both datasets, the variable import will succeed. If variables do not match exactly (for example, a value code was added to a variable) then there is a chance the crosstab that is built on that variable will not be imported. Deselecting this option allows MarketSight some leeway, but the import may not succeed if too many variables are too different.

Scenarios Where Crosstab Import Fails

If ...

"Only Import Exact Matches"
 CHECKED

"Only Import Exact   Matches"
 NOT CHECKED
Your crosstab contains a column, filter, index or weight variable that does not exist in the target dataset Crosstab import fails. The variable is removed from the crosstab design. If a viable crosstab remains, import proceeds.
If the column, filter, index or weight variable is a different type (i.e., continuous, categorical) in the target dataset Crosstab import fails. The variable is removed from the crosstab design. If a viable crosstab remains, import proceeds.
Your crosstab contains a row variable that does not exist or is different in the target dataset The variable is removed from the crosstab design. If a viable crosstab remains, import proceeds. The variable is removed from the crosstab design. If a viable crosstab remains, import proceeds.
Your crosstab contains a column, filter, or index variable which has missing/modified values or value labels in the target dataset If some values are deselected in the source crosstab, the import will fail. Otherwise, import proceeds and all of the values are selected in the copied crosstab. Values are selected based on matching codes in the source and target variables. Import proceeds.
Your crosstab contains a row variable which has missing/modified values or value labels in the target dataset If some values are deselected in the source crosstab, the import will fail. Otherwise, import proceeds and all of the values are selected in the copied crosstab. Values are selected based on matching codes in the source and target variables. Import proceeds.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us