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
@bdewitt760 , have you checked the release notes? https://help.alteryx.com/release-notes
I looked through them and didn't see this issue referenced
I am encountering the same issue, any resolution or still not figured out?