Alteryx SQL Editor adding spaces before and after dashes
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bdewitt760 , have you checked the release notes? https://help.alteryx.com/release-notes
Sales Engineer - LATAM -
Alteryx, Inc.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I looked through them and didn't see this issue referenced
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am encountering the same issue, any resolution or still not figured out?
