Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Query Deletes from my input tool when I try to edit

Highlighted
7 - Meteor

Cannot edit my query because it deletes each time I go to edit. Even if I just select the input it deletes the query. Has anyone else seen this bug in 11.5?

 

pic1.PNGpic2.PNG

 

 

Highlighted
Alteryx
Alteryx

Hi @mreinsch,

 

This was a known issue for 11.5. It was fixed in 2018.1 and included in a stable update for 11.7. You can also workaround the issue by opening the workflow in a text editor and adding a semicolon prior to the pipe character separating the connection string from the query string. For example...

 

Original - odbc:DSN=Connection;UID=user;PWD=__EncPwd1__|Select BLAH.dbo.BLUE.COLUMN, BLAH.dbo.BLUE...

 

Revised - odbc:DSN=Connection;UID=user;PWD=__EncPwd1__;|Select BLAH.dbo.BLUE.COLUMN, BLAH.dbo.BLUE...

 

Please let me know if this helps.

 

Jerad Rades

Sr. Customer Support Engineer

Labels