Why does SQL query in Table Transformer show "Parse error on line 1"?

Leonie Guzy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 7, 2023

Hi there,

we have merged some Tables eith the Table Transformer to sum up some Data.
It is for a simple Capacity Planning.

All of the sudden (yesterday it worked fine), the SQL in the Table Transformer does show the follwing error:

SQL:
SELECT
sum (T1.'Sprint 1'+'Sprint 2'+'Sprint 3'+'Sprint 4'+'Sprint 5')
as Total FROM T1

Error:
SyntaxError: Parse error on line 1: ...4`+`Sprint 5`) as Total FROM T1 -----------------------^ Expecting 'LITERAL', 'BRALITERAL', 'NUMBER', 'STRING', 'NSTRING', got 'TOTAL'

Can someone help to fix the SQL? It´s quite urgent.
And tell me, why it does not work anymore?

Thanks in advance!
Leonie

1 answer

1 accepted

2 votes
Answer accepted
Leonie Guzy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 7, 2023

Found the answer

Total needs a warm embrace of two little ''

'Total'

as Muhammad Ali said (as the internet says):
"It's not the mountain that seems so high for you to climb, it's the pebble in your shoe"

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 7, 2023

Hi @Leonie Guzy ,

You were faster than us! :)

Glad that everything works as expected.

As usual, ' ' quotes are used to refer to a column and " " stands for a string. 

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events