Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
2
votes
1 answer

Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A

I'm trying to get a random meal planner set up and am stuck on getting this error message, "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A" on this piece of…
Pikie
  • 23
  • 5
2
votes
2 answers

Google Spreadsheet, How to search an entire sheet for same matches and return values located to the right of them?

In Sheet1 I have many values that are the same, for example the name "boland1" exists in many places in Sheet1 and although the content is stuctured, the positions vary. Each "boland1" have different values to the right of them, which is what I want…
Axxi
  • 193
  • 1
  • 10
2
votes
1 answer

Using ARRAYFORMULA with SUMIF for multiple conditions combined with a wildcard to select all values for a given condition

I am using ARRAYFORMULA with multiple conditions using SUMIF concatenating the conditions using & and it works. Now I would like to use similarly this idea for a special condition indicating to consider all values using a wildcard ("ALL") for a…
David Leal
  • 6,373
  • 4
  • 29
  • 56
2
votes
2 answers

Google Query Trim string data

I am using the following data: cat1-001A cat1-001B cat1-001C dog2-001A etc. the query I used is =query(sheet1!A1:A,"select A where A is like '%cat%'",1) Using this query pulls data as cat 1-3. Is there a way within the query to trim the text to…
T17
  • 33
  • 5
2
votes
1 answer

Exclude a string from ARRAYFORMULA

So i'm using ARRAYFORMULA to grab a list of strings from another sheet. I only want strings which don't contain "USD". How do I program my cell to collect data which excludes the string "USD"? =ARRAYFORMULA(Account!A4:A100)
rusty_research
  • 57
  • 5
2
votes
1 answer

How to using ABS equivalent in this query formula in Google Sheets?

The formula converts negative into positive and vice versa, but how can I get all numbers in Col8 to be positive? =query(UNIQUE(IMPORTRANGE("https://docs.google.com/spreadsheets/d/ddddddddddddsssssssssssssssswwwwwwww/edit";"Sheet1!A1:K"));"select…
onit
  • 2,275
  • 11
  • 25
2
votes
2 answers

Count Number of Consecutive Occurrence of values in Google sheets

This is the original data, all the data are of two kinds: red and black. And then, I want to study the occurrence of all the blocks. The result will be like this: It means the first streak of red(from index 1 to 3) has a length of 3, and the…
zzzgoo
  • 1,974
  • 2
  • 17
  • 34
2
votes
1 answer

Google Sheets: How to combine multiple rows in their own cells according to an ID?

I tried searching for this question very hard, and only managed to find one solution that sort of works. Here's the reference: how to merge rows together if duplicate id (google spreadsheet) His question is exactly the same as mine, and the solution…
0x00n0b0dy
  • 25
  • 1
  • 7
2
votes
1 answer

Google Sheets QUERY pulling from a list of tab names which will pull new tab data as new tabs are added

I have a Google Apps Script pulling the names of each tab in my Google Sheet into one list. The tabs are labeled by month and year (i.e., February 2020) but I don't have a tab for every single month since February. I create a new tab for months when…
allison
  • 169
  • 8
2
votes
1 answer

Google Sheets - Combine multiple columns into one with unique values

I currently have 6 columns that are populating from another sheet with the query formula, based on column name. I would like to combine these 6 columns into one column, eliminating duplicates, and listing them all in one-singular column. I've tried…
Brian
  • 39
  • 1
  • 6
2
votes
1 answer

Filtering multiple columns in Google Sheets without blanks

So basically, I have a google sheets sheet that has form answers, but depending on what they answered in the google forms they'll answer different questions. So I basically have a filter function that filters these answers and sorts them by category…
TWVD
  • 35
  • 4
2
votes
4 answers

Stack multiple columns on top of eachother on Google Sheet?

I am using Google SpreadSheet, and I'm trying to import data from different sources together using a combination of query, importrange and curly brackets: ={Query(Importrange(SheetA),"select Col1,Col2,Col3,Col4 where Col1 is not…
Trung Pham
  • 33
  • 6
2
votes
1 answer

Google Sheets pivot data with multiple values

I'm trying to display sample data as follows. I'm able to do this using pivot tables and multiple values with no problem but would like to find a way using either Query or some other method. This problem was partly solved using the formula below but…
herman
  • 123
  • 10
2
votes
1 answer

Is there a way to make this query formula work? it was working before but I had to add more sheets and then it broke

Formula that combines all the sheets in my project and removes any empty cells
Ervin001
  • 25
  • 3
2
votes
1 answer

Google sheets copy drag formula

How do I copy purple numbers from the right side when using a copy-drag? What should be the formula for it to work?
Edvard
  • 163
  • 8
1 2 3
…
74 75