community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Query Deletes from my input tool when I try to edit

Highlighted
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

 

 

Moderator
Moderator

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