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

[Leonie Guzy]

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

[Leonie Guzy · Accepted solution]

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]

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.