In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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 Alumni (Retired)

@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
Top Solution Authors