--- title: "Solution to the error \"The number of columns in the data does not match the number of columns in the range\"" description: Did you try to modify a query and got the error "The number of columns in the data does not match the number of columns in the range"? --- [Skip to content](https://support.dataslayer.ai/solution-to-the-error-the-number-of-columns-in-the-data-does-not-match-the-number-of-columns-in-the-range#main-content) - [English](https://support.dataslayer.ai/solution-to-the-error-the-number-of-columns-in-the-data-does-not-match-the-number-of-columns-in-the-range) - [Español](https://support.dataslayer.ai/es/solución-al-error-the-number-of-columns-in-the-data-does-not-match-the-number-of-columns-in-the-range) English Show submenu for translations [![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/) Open main navigation Close main navigation - - [English](https://support.dataslayer.ai/solution-to-the-error-the-number-of-columns-in-the-data-does-not-match-the-number-of-columns-in-the-range) - [Español](https://support.dataslayer.ai/es/solución-al-error-the-number-of-columns-in-the-data-does-not-match-the-number-of-columns-in-the-range) English Show submenu for translations Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en) 2. [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en) May 28, 2024 # Solution to the error "The number of columns in the data does not match the number of columns in the range" ## Did you try to modify a query and got the error "The number of columns in the data does not match the number of columns in the range"? Don´t worry, this happens because you tried to modify a query with the** "combine new with old results"** option selected. Follow these steps to fix it: 1. Click on **Modify to modify the query** **If you don't know how to modify a query click [here](https://support.dataslayer.ai/how-can-i-modify-a-pre-existing-query?hsLang=en)** ![Browser template-May-28-2024-08-31-23-7892-AM](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template-May-28-2024-08-31-23-7892-AM.png?width=688&height=252&name=Browser%20template-May-28-2024-08-31-23-7892-AM.png) 2.  **Uncheck** the option **"combine new with old results"** **If you do not deselect this option, the error will not be solved.** **Don't worry, you can select it again later.** ![Browser template (1)-May-28-2024-08-36-40-5808-AM](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template%20(1)-May-28-2024-08-36-40-5808-AM.png?width=688&height=252&name=Browser%20template%20(1)-May-28-2024-08-36-40-5808-AM.png) 3.  **Modify your query** by selecting the new desired parameters. 4.  **Click on confirm changes.** This will generate the table with the new modifications. ![Browser template (2)-May-28-2024-08-39-25-5052-AM](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template%20(2)-May-28-2024-08-39-25-5052-AM.png?width=688&height=252&name=Browser%20template%20(2)-May-28-2024-08-39-25-5052-AM.png) 5.  Modify again, and **select "combine new with old results".** ![Browser template-May-28-2024-08-31-23-7892-AM](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template-May-28-2024-08-31-23-7892-AM.png?width=688&height=252&name=Browser%20template-May-28-2024-08-31-23-7892-AM.png) ![Browser template (1)-May-28-2024-08-36-40-5808-AM](https://support.dataslayer.ai/hs-fs/hubfs/Browser%20template%20(1)-May-28-2024-08-36-40-5808-AM.png?width=688&height=252&name=Browser%20template%20(1)-May-28-2024-08-36-40-5808-AM.png) 6.  **Confirm** changes and you will have your modified query without the error.   As always, please contact us via our live chat on our [website](https://dataslayer.ai/) or via [email](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!   - [General](https://support.dataslayer.ai/general?hsLang=en) - [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en) - [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en) - [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en) - [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en) - [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en) - [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en) - [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en) - [Big Query](https://support.dataslayer.ai/big-query?hsLang=en) - [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en) - [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en) - [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en) - [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en) - [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content) - [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace) - [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en) - [Database](https://support.dataslayer.ai/database?hsLang=en) - [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en) - [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en) - [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en) - [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en) - [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en) - [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en) - [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en) - [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en) [![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/) Dataslayer.ai: Digital Marketing Reporting Made Easy Copyright © 2026, DATASLAYER SL