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

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"