topic Re: Syntax error in Alteryx Designer Desktop Discussions

Syntax error

jonathangonzales — Thu, 24 May 2018 04:11:13 GMT

I am trying to use SQL Editor on an Input Tool. I am able to run this query just fine in Teradata, but when I paste into SQL Editor I am getting the error below. Anyone know of an easy way to correct issue without having to manually re-type the entire query?

select	a11.WK_IDNT  WK_IDNT,
	max(a15.WK_DESC)  WK_DESC,
	max(a15.WK_END_DT)  WK_END_DT,

above is the SQL the error is calling out and below is the error message.

Re: Syntax error

JohnJPS — Fri, 08 Sep 2017 13:05:24 GMT

Just fishing in the dark, but the nature of the message suggests that it's regarding "a15" as a variable (rather than a table), and then gets confused by the period. Can you confirm that you have a table in your SQL that is being aliased as "a15"? I'm guessing you do, but just thought I'd ask.

Re: Syntax error

jonathangonzales — Mon, 11 Sep 2017 13:14:52 GMT

For some reason Alteryx did not like the tabs after Select, From, and Where.