Alteryx Designer Desktop Discussions

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

Alteryx SQL Editor adding spaces before and after dashes

bdewitt760
5 - Atom

Hope someone can help - Alteryx changes my sql code by adding spaces before and after dash/hypen.   

 

Step 1 I put this functioning workflow into the SQL Editor:

Select *

from `alpha-data-main-bfg.D6_FACT_MAC.WJ_BT_APPLES`

(works great)

 

Step 2.  Click on the Visual Query Builder and add/remove columns / change anything.   

Then click back on SQL Editor and my code has changed to 

Select *

from `alpha - data - main - bfg.D6_FACT_MAC.WJ_BT_APPLES`

(spaces added before and after dashes)

 

Now my query won't run and gives error messages indicating that the data source doesn't exist.  

So i have to go back in and find/replace to remove the spaces Alteryx added. 

 

Is this a known problem with a solution? 

I'm on Version: 2020.4.6.36807

 

Thank you for the help--

Bryan

 

 

3 REPLIES 3
AZuc
Alteryx
Alteryx

@bdewitt760 , have you checked the release notes? https://help.alteryx.com/release-notes

 

André Zuccatti

Sales Engineer - LATAM -
Alteryx, Inc.


bdewitt760
5 - Atom

I looked through them and didn't see this issue referenced

NawfalMahmood
5 - Atom

I am encountering the same issue, any resolution or still not figured out?

Labels