Converting Existing Queries
Converting existing queries to a different query type is a supported feature.
Some common uses for this are:
A crosstab query is already populated with data, but visualizations are needed.
A query is already built for visualizations, but additional crosstab functionality is needed.
Additional questions are added to the query that will change the required analysis or visualization (e.g. need to change a Structure Analysis to a Scatterplot).
Select the query to convert and click the CHANGE button.
This example is converting an existing Crosstab query to a different query type.
These specific options are what are available when changing templates from Crosstab.
When changing from Crosstab, it’s possible to use a Pivot table or visualization option such as Structure Analysis, Frequency Analysis, or Scatterplot.
The yellow dot beside the options indicate that it’s possible to convert the template from Crosstab to another option, but the change will not be lossless (i.e. some information from the Crosstab query will not be included in the new template).
A gray dot means the option is not available.
After selecting one of the conversion options listed above, the Tab Conversion Warning message may appear.
Click Proceed to continue with the conversion or click Make copy to keep the existing tab as is, but make a copy of it before continuing with the conversion.
Examples of information that will be dropped are other types of formatting not assigned as the Main Statistic, such as Sample Total, Subset Total, and Unweighted Sample count.
After the the conversion completes, a status message will appear at the bottom-left corner of the screen.
If conversion was successful, the "No errors" message will appear.
If any errors were encountered during conversion, a description of the error(s) will be indicated with a red warning.
