Google Sheets query, unable to decipher error message

up vote
0
down vote

favorite

I am trying to copy data over from one sheet to another using Google Sheets and am using this query in the second sheet

=query(IMPORTRANGE("5UAxxxxxxxxxxxx-GMcxccccccccp-xsdff0","SheetName!A4:AI1000"),"select Col1, Col2, Col3, Col5, Col7, Col9, Col14, Col16, Col 18, Col19, Col20, Col21 where Col35 = 'Yes'")

Unable to understand what this error means.

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <INTEGER_LITERAL> "18 "" at line 1, column 62. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ... "/" ... "%" ... "*" ... "/" ... "%" ... "+" ... "-" ...

My Sheet1 where I am copying data from has columns A-Z and AA-AI, so I have A4:AI1000 to capture all the data assuming we won't have more than 1000 records with the headers taking up from 1-3 rows.

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

add a comment |

up vote
0
down vote

favorite

I am trying to copy data over from one sheet to another using Google Sheets and am using this query in the second sheet

=query(IMPORTRANGE("5UAxxxxxxxxxxxx-GMcxccccccccp-xsdff0","SheetName!A4:AI1000"),"select Col1, Col2, Col3, Col5, Col7, Col9, Col14, Col16, Col 18, Col19, Col20, Col21 where Col35 = 'Yes'")

Unable to understand what this error means.

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <INTEGER_LITERAL> "18 "" at line 1, column 62. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ... "/" ... "%" ... "*" ... "/" ... "%" ... "+" ... "-" ...

My Sheet1 where I am copying data from has columns A-Z and AA-AI, so I have A4:AI1000 to capture all the data assuming we won't have more than 1000 records with the headers taking up from 1-3 rows.

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

add a comment |

up vote
0
down vote

favorite

I am trying to copy data over from one sheet to another using Google Sheets and am using this query in the second sheet

=query(IMPORTRANGE("5UAxxxxxxxxxxxx-GMcxccccccccp-xsdff0","SheetName!A4:AI1000"),"select Col1, Col2, Col3, Col5, Col7, Col9, Col14, Col16, Col 18, Col19, Col20, Col21 where Col35 = 'Yes'")

Unable to understand what this error means.

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <INTEGER_LITERAL> "18 "" at line 1, column 62. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ... "/" ... "%" ... "*" ... "/" ... "%" ... "+" ... "-" ...

My Sheet1 where I am copying data from has columns A-Z and AA-AI, so I have A4:AI1000 to capture all the data assuming we won't have more than 1000 records with the headers taking up from 1-3 rows.

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

I am trying to copy data over from one sheet to another using Google Sheets and am using this query in the second sheet

=query(IMPORTRANGE("5UAxxxxxxxxxxxx-GMcxccccccccp-xsdff0","SheetName!A4:AI1000"),"select Col1, Col2, Col3, Col5, Col7, Col9, Col14, Col16, Col 18, Col19, Col20, Col21 where Col35 = 'Yes'")

Unable to understand what this error means.

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <INTEGER_LITERAL> "18 "" at line 1, column 62. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset" ... "label" ... "format" ... "options" ... "," ... "*" ... "+" ... "-" ... "/" ... "%" ... "*" ... "/" ... "%" ... "+" ... "-" ...

My Sheet1 where I am copying data from has columns A-Z and AA-AI, so I have A4:AI1000 to capture all the data assuming we won't have more than 1000 records with the headers taking up from 1-3 rows.

google-sheets

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

edited Nov 12 at 20:27

Jonathon

2,94531940

edited Nov 12 at 20:27

Jonathon

2,94531940

edited Nov 12 at 20:27

Jonathon

2,94531940

asked Nov 12 at 20:04

p0tta

1932520

asked Nov 12 at 20:04

p0tta

1932520

asked Nov 12 at 20:04

p0tta

1932520

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

accepted

A simple one, you have a space between in the column reference Col 18.

The error message was pretty clear:

QUERY Parameter 2 is the query string itself

Encountered " <INTEGER_LITERAL> "18 "" means that it found the number 18 when it was expecting either a column reference or an SQL clause…

answered Nov 12 at 20:26

Jonathon

2,94531940

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53269330%2fgoogle-sheets-query-unable-to-decipher-error-message%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

accepted

A simple one, you have a space between in the column reference Col 18.

The error message was pretty clear:

QUERY Parameter 2 is the query string itself

Encountered " <INTEGER_LITERAL> "18 "" means that it found the number 18 when it was expecting either a column reference or an SQL clause…

answered Nov 12 at 20:26

Jonathon

2,94531940

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

add a comment |

up vote
0
down vote

accepted

A simple one, you have a space between in the column reference Col 18.

The error message was pretty clear:

QUERY Parameter 2 is the query string itself

Encountered " <INTEGER_LITERAL> "18 "" means that it found the number 18 when it was expecting either a column reference or an SQL clause…

answered Nov 12 at 20:26

Jonathon

2,94531940

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

add a comment |

up vote
0
down vote

accepted

A simple one, you have a space between in the column reference Col 18.

The error message was pretty clear:

QUERY Parameter 2 is the query string itself

Encountered " <INTEGER_LITERAL> "18 "" means that it found the number 18 when it was expecting either a column reference or an SQL clause…

answered Nov 12 at 20:26

Jonathon

2,94531940

A simple one, you have a space between in the column reference Col 18.

The error message was pretty clear:

QUERY Parameter 2 is the query string itself

Encountered " <INTEGER_LITERAL> "18 "" means that it found the number 18 when it was expecting either a column reference or an SQL clause…

answered Nov 12 at 20:26

Jonathon

2,94531940

answered Nov 12 at 20:26

Jonathon

2,94531940

answered Nov 12 at 20:26

Jonathon

2,94531940

answered Nov 12 at 20:26

Jonathon

2,94531940

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

add a comment |

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

Thanks! I wasn't sure if this was data related or query related but this solved the issue.
– p0tta
Nov 12 at 20:34

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky