Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

SQL Editor

Hi2023
8 - Asteroid

Hi,

 

still learning SQL editor, 

 

I get 

 

Invalid Select statement 

Unexpected token "" at Line 56 POS 1

 

is that line 56 not counting the skipped lines in between? Also is it referencing only the "" as wrong? I am trying to see what is wrong.

 

The one thing I see is 

 

'Customer' as Customer_Non,

’Other’ as Association_Cat,

'Individual' as Subject_Call,

 

'Customer' and 'Individual' are in red BUT 'Other' is not red, it is black

 

 

is that the problem?

 

thanks

 

1 REPLY 1
geraldo
13 - Pulsar

@Hi2023 

 

the problem is in the quotes in others it is not quotes

 

 

geraldo_0-1683226608612.png

 

Labels